[dbo].[DisplayTemplateLocalizations]

(local) > SupportBridge > Tables > dbo.DisplayTemplateLocalizations

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key pk_DispTemplateLoc: localizationID\eventType$	localizationID	int	4
$Cluster Primary Key pk_DispTemplateLoc: localizationID\eventType$	eventType	int	4
	displayTemplate	nvarchar(510)	1020

Indexes

	Name	Columns	Unique
$Cluster Primary Key pk_DispTemplateLoc: localizationID\eventType$	pk_DispTemplateLoc	localizationID, eventType

SQL Script

CREATE TABLE [dbo].[DisplayTemplateLocalizations]
(
[localizationID] [int] NOT NULL,
[eventType] [int] NOT NULL,
[displayTemplate] [nvarchar] (510) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DisplayTemplateLocalizations] ADD CONSTRAINT [pk_DispTemplateLoc] PRIMARY KEY CLUSTERED ([localizationID], [eventType]) ON [PRIMARY]
GO

Uses