[dbo].[ScriptGroupJoin]

Property	Value
Row Count	12
Created	12:44:45 PM Thursday, October 04, 2007
Last Modified	12:44:45 PM Thursday, October 04, 2007

Property

Value

Row Count

Created

12:44:45 PM Thursday, October 04, 2007

Last Modified

12:44:45 PM Thursday, October 04, 2007

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key pk_scriptgroup: groupID\scriptID$	groupID	int	4
$Cluster Primary Key pk_scriptgroup: groupID\scriptID$	scriptID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_scriptgroup: groupID\scriptID$

groupID

int

$Cluster Primary Key pk_scriptgroup: groupID\scriptID$

scriptID

int

	Name	Columns	Unique
$Cluster Primary Key pk_scriptgroup: groupID\scriptID$	pk_scriptgroup	groupID, scriptID

Name

Columns

Unique

$Cluster Primary Key pk_scriptgroup: groupID\scriptID$

pk_scriptgroup

groupID, scriptID

Name	Columns
fk_scriptgroup_group	groupID->[dbo].[ScriptGroups].[groupID]
fk_scriptgroup_script	scriptID->[dbo].[Scripts].[scriptID]

Name

Columns

fk_scriptgroup_group

groupID->[dbo].[ScriptGroups].[groupID]

fk_scriptgroup_script

scriptID->[dbo].[Scripts].[scriptID]

SQL Script

CREATE TABLE [dbo].[ScriptGroupJoin]
(
[groupID] [int] NOT NULL,
[scriptID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptGroupJoin] ADD CONSTRAINT [pk_scriptgroup] PRIMARY KEY CLUSTERED ([groupID], [scriptID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptGroupJoin] ADD CONSTRAINT [fk_scriptgroup_group] FOREIGN KEY ([groupID]) REFERENCES [dbo].[ScriptGroups] ([groupID])
GO
ALTER TABLE [dbo].[ScriptGroupJoin] ADD CONSTRAINT [fk_scriptgroup_script] FOREIGN KEY ([scriptID]) REFERENCES [dbo].[Scripts] ([scriptID])
GO