[dbo].[DivisionBrandingLocalized]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	7
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_brandlocal: divisionID\localizationID$	divisionID	int	4
$Cluster Primary Key pk_brandlocal: divisionID\localizationID$	localizationID	int	4
	stylesheetURL	nvarchar(512)	1024
	header	ntext	max
	footer	ntext	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key pk_brandlocal: divisionID\localizationID$

divisionID

int

$Cluster Primary Key pk_brandlocal: divisionID\localizationID$

localizationID

int

stylesheetURL

nvarchar(512)

1024

header

ntext

max

footer

ntext

max

	Name	Columns	Unique
$Cluster Primary Key pk_brandlocal: divisionID\localizationID$	pk_brandlocal	divisionID, localizationID

Name

Columns

Unique

$Cluster Primary Key pk_brandlocal: divisionID\localizationID$

pk_brandlocal

divisionID, localizationID

Name	Columns
fk_brandlocal_div	divisionID->[dbo].[Divisions].[divisionID]
fk_brandlocal_local	localizationID->[dbo].[Localizations].[localizationID]

Name

Columns

fk_brandlocal_div

divisionID->[dbo].[Divisions].[divisionID]

fk_brandlocal_local

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

SQL Script

CREATE TABLE [dbo].[DivisionBrandingLocalized]
(
[divisionID] [int] NOT NULL,
[localizationID] [int] NOT NULL,
[stylesheetURL] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[header] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[footer] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DivisionBrandingLocalized] ADD CONSTRAINT [pk_brandlocal] PRIMARY KEY CLUSTERED ([divisionID], [localizationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DivisionBrandingLocalized] ADD CONSTRAINT [fk_brandlocal_div] FOREIGN KEY ([divisionID]) REFERENCES [dbo].[Divisions] ([divisionID])
GO
ALTER TABLE [dbo].[DivisionBrandingLocalized] ADD CONSTRAINT [fk_brandlocal_local] FOREIGN KEY ([localizationID]) REFERENCES [dbo].[Localizations] ([localizationID])
GO