Tables [cohesion].[cc_named_elem]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count2426
Created11:18:10 AM Friday, April 20, 2007
Last Modified11:18:10 AM Friday, April 20, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__cc_named_elem__10566F31: element_idForeign Keys FK__cc_named___eleme__114A936A: [cohesion].[cc_element].element_idelement_idint4
No
Indexes XIE1cc_named_elem: elem_nameelem_namevarchar(90)90
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__cc_named_elem__10566F31: element_idPK__cc_named_elem__10566F31element_id
Yes
XIE1cc_named_elemelem_name
Foreign Keys Foreign Keys
NameColumns
FK__cc_named___eleme__114A936Aelement_id->[cohesion].[cc_element].[element_id]
SQL Script
CREATE TABLE [cohesion].[cc_named_elem]
(
[element_id] [int] NOT NULL,
[elem_name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_named_elem] ADD CONSTRAINT [PK__cc_named_elem__10566F31] PRIMARY KEY CLUSTERED ([element_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [XIE1cc_named_elem] ON [cohesion].[cc_named_elem] ([elem_name]) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cc_named_elem] ADD CONSTRAINT [FK__cc_named___eleme__114A936A] FOREIGN KEY ([element_id]) REFERENCES [cohesion].[cc_element] ([element_id])
GO
Uses