[dbo].[SecurityGroupsLocalized]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	42
Created	12:44:47 PM Thursday, October 04, 2007
Last Modified	12:44:47 PM Thursday, October 04, 2007

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_secgrplocale: groupID\localizationID$	groupID	int	4
$Cluster Primary Key pk_secgrplocale: groupID\localizationID$	localizationID	int	4
	groupName	nvarchar(50)	100
	description	nvarchar(512)	1024

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_secgrplocale: groupID\localizationID$

groupID

int

$Cluster Primary Key pk_secgrplocale: groupID\localizationID$

localizationID

int

groupName

nvarchar(50)

100

description

nvarchar(512)

1024

	Name	Columns	Unique
$Cluster Primary Key pk_secgrplocale: groupID\localizationID$	pk_secgrplocale	groupID, localizationID

Name

Columns

Unique

$Cluster Primary Key pk_secgrplocale: groupID\localizationID$

pk_secgrplocale

groupID, localizationID

Name	Columns
fk_secgrplocale_loc	localizationID->[dbo].[Localizations].[localizationID]
fk_secgrplocale_secgrps	groupID->[dbo].[SecurityGroups].[groupID]

Name

Columns

fk_secgrplocale_loc

localizationID->[dbo].[Localizations].[localizationID]

fk_secgrplocale_secgrps

groupID->[dbo].[SecurityGroups].[groupID]

SQL Script

CREATE TABLE [dbo].[SecurityGroupsLocalized]
(
[groupID] [int] NOT NULL,
[localizationID] [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
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroupsLocalized] ADD CONSTRAINT [pk_secgrplocale] PRIMARY KEY CLUSTERED ([groupID], [localizationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SecurityGroupsLocalized] ADD CONSTRAINT [fk_secgrplocale_loc] FOREIGN KEY ([localizationID]) REFERENCES [dbo].[Localizations] ([localizationID])
GO
ALTER TABLE [dbo].[SecurityGroupsLocalized] ADD CONSTRAINT [fk_secgrplocale_secgrps] FOREIGN KEY ([groupID]) REFERENCES [dbo].[SecurityGroups] ([groupID])
GO