Tables [dbo].[DTA_reports_column]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created1:20:07 PM Friday, May 11, 2007
Last Modified1:20:07 PM Friday, May 11, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__DTA_reports_colu__5832119F: ColumnIDColumnIDint4
No
1 - 1
Foreign Keys FK__DTA_repor__Table__592635D8: [dbo].[DTA_reports_table].TableIDIndexes DTA_reports_column_index: TableIDTableIDint4
No
ColumnName[sys].[sysname]256
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__DTA_reports_colu__5832119F: ColumnIDPK__DTA_reports_colu__5832119FColumnID
Yes
DTA_reports_column_indexTableID
Foreign Keys Foreign Keys
NameDeleteColumns
FK__DTA_repor__Table__592635D8CascadeTableID->[dbo].[DTA_reports_table].[TableID]
SQL Script
CREATE TABLE [dbo].[DTA_reports_column]
(
[ColumnID] [int] NOT NULL IDENTITY(1, 1),
[TableID] [int] NOT NULL,
[ColumnName] [sys].[sysname] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_column] ADD CONSTRAINT [PK__DTA_reports_colu__5832119F] PRIMARY KEY CLUSTERED ([ColumnID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_column_index] ON [dbo].[DTA_reports_column] ([TableID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_column] ADD CONSTRAINT [FK__DTA_repor__Table__592635D8] FOREIGN KEY ([TableID]) REFERENCES [dbo].[DTA_reports_table] ([TableID]) ON DELETE CASCADE
GO
Uses
Used By