CREATE TABLE [dbo].[SecurityGroups]
(
[groupID] [int] NOT NULL IDENTITY(1, 1),
[divisionID] [int] NOT NULL,
[groupName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rank] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroups] ADD CONSTRAINT [pk_securitygroups] PRIMARY KEY CLUSTERED ([groupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroups] ADD CONSTRAINT [fk_securitygroups_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
[dbo].[SecurityGroups]
![Foreign Keys fk_securitygroups_div: [dbo].[Divisions].divisionID](../../Images/fk.gif)
