[dbo].[DTA_reports

Property	Value
Row Count	0
Created	1:20:07 PM Friday, May 11, 2007
Last Modified	1:20:07 PM Friday, May 11, 2007

Property

Value

Row Count

Created

1:20:07 PM Friday, May 11, 2007

Last Modified

1:20:07 PM Friday, May 11, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	TableID	int	4
	ViewID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

TableID

int

ViewID

int

	Name	Columns
	DTA_reports_tableview_index	TableID
	DTA_reports_tableview_index2	ViewID

Name

Columns

DTA_reports_tableview_index

TableID

DTA_reports_tableview_index2

ViewID

Name	Delete	Columns
FK__DTA_repor__Table__4242D080	Cascade	TableID->[dbo].[DTA_reports_table].[TableID]
FK__DTA_repor__ViewI__4336F4B9		ViewID->[dbo].[DTA_reports_table].[TableID]

Name

Delete

Columns

FK__DTA_repor__Table__4242D080

Cascade

TableID->[dbo].[DTA_reports_table].[TableID]

FK__DTA_repor__ViewI__4336F4B9

ViewID->[dbo].[DTA_reports_table].[TableID]

SQL Script

CREATE TABLE [dbo].[DTA_reports_tableview]
(
[TableID] [int] NOT NULL,
[ViewID] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [DTA_reports_tableview_index] ON [dbo].[DTA_reports_tableview] ([TableID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [DTA_reports_tableview_index2] ON [dbo].[DTA_reports_tableview] ([ViewID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DTA_reports_tableview] ADD CONSTRAINT [FK__DTA_repor__Table__4242D080] FOREIGN KEY ([TableID]) REFERENCES [dbo].[DTA_reports_table] ([TableID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DTA_reports_tableview] ADD CONSTRAINT [FK__DTA_repor__ViewI__4336F4B9] FOREIGN KEY ([ViewID]) REFERENCES [dbo].[DTA_reports_table] ([TableID])
GO