[dbo].[TriggerGroupJoin]

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

Property

Value

Row Count

Created

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

Last Modified

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

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

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK__TriggerGroupJoin__703EA55A: triggerID\groupID$

triggerID

int

$Cluster Primary Key PK__TriggerGroupJoin__703EA55A: triggerID\groupID$

groupID

int

	Name	Columns	Unique
$Cluster Primary Key PK__TriggerGroupJoin__703EA55A: triggerID\groupID$	PK__TriggerGroupJoin__703EA55A	triggerID, groupID

Name

Columns

Unique

$Cluster Primary Key PK__TriggerGroupJoin__703EA55A: triggerID\groupID$

PK__TriggerGroupJoin__703EA55A

triggerID, groupID

Name	Columns
FK__TriggerGr__group__7226EDCC	groupID->[dbo].[SHGroup].[groupID]
FK__TriggerGr__trigg__7132C993	triggerID->[dbo].[Triggers].[triggerID]

Name

Columns

FK__TriggerGr__group__7226EDCC

groupID->[dbo].[SHGroup].[groupID]

FK__TriggerGr__trigg__7132C993

triggerID->[dbo].[Triggers].[triggerID]

SQL Script

CREATE TABLE [dbo].[TriggerGroupJoin]
(
[triggerID] [int] NOT NULL,
[groupID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TriggerGroupJoin] ADD CONSTRAINT [PK__TriggerGroupJoin__703EA55A] PRIMARY KEY CLUSTERED ([triggerID], [groupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TriggerGroupJoin] ADD CONSTRAINT [FK__TriggerGr__group__7226EDCC] FOREIGN KEY ([groupID]) REFERENCES [dbo].[SHGroup] ([groupID])
GO
ALTER TABLE [dbo].[TriggerGroupJoin] ADD CONSTRAINT [FK__TriggerGr__trigg__7132C993] FOREIGN KEY ([triggerID]) REFERENCES [dbo].[Triggers] ([triggerID])
GO