Tables [dbo].[ToolInstanceLogEventJoin]
Properties
PropertyValue
Row Count1273
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventIDtoolInstanceLogIDint4
No
Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventIDeventIDdecimal(28,0)13
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_TILEventJoin: toolInstanceLogID\eventIDpk_TILEventJointoolInstanceLogID, eventID
Yes
SQL Script
CREATE TABLE [dbo].[ToolInstanceLogEventJoin]
(
[toolInstanceLogID] [int] NOT NULL,
[eventID] [decimal] (28, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ToolInstanceLogEventJoin] ADD CONSTRAINT [pk_TILEventJoin] PRIMARY KEY CLUSTERED ([toolInstanceLogID], [eventID]) ON [PRIMARY]
GO
Uses