[dbo].[ScriptRoleJoin]

Property	Value
Row Count	10
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)	Default
$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$	scriptID	int	4
$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$	roleID	int	4
	autorun	bit	1	((0))

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$

scriptID

int

$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$

roleID

int

autorun

bit

((0))

	Name	Columns	Unique
$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$	pk_scriptrolejoin	scriptID, roleID

Name

Columns

Unique

$Cluster Primary Key pk_scriptrolejoin: scriptID\roleID$

pk_scriptrolejoin

scriptID, roleID

Name	Columns
fk_scriptrole_role	roleID->[dbo].[Roles].[roleID]
fk_scriptrole_script	scriptID->[dbo].[Scripts].[scriptID]

Name

Columns

fk_scriptrole_role

roleID->[dbo].[Roles].[roleID]

fk_scriptrole_script

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

SQL Script

CREATE TABLE [dbo].[ScriptRoleJoin]
(
[scriptID] [int] NOT NULL,
[roleID] [int] NOT NULL,
[autorun] [bit] NULL CONSTRAINT [DF__ScriptRol__autor__02084FDA] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptRoleJoin] ADD CONSTRAINT [pk_scriptrolejoin] PRIMARY KEY CLUSTERED ([scriptID], [roleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScriptRoleJoin] ADD CONSTRAINT [fk_scriptrole_role] FOREIGN KEY ([roleID]) REFERENCES [dbo].[Roles] ([roleID])
GO
ALTER TABLE [dbo].[ScriptRoleJoin] ADD CONSTRAINT [fk_scriptrole_script] FOREIGN KEY ([scriptID]) REFERENCES [dbo].[Scripts] ([scriptID])
GO