Tables [dbo].[UNITSEC]
Properties
PropertyValue
HeapYes
Row Count0
Created3:44:42 PM Friday, June 13, 2003
Last Modified3:44:42 PM Friday, June 13, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDUDOMIDint4
No
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDUNITIDint4
No
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDTYPEint4
No
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDTYPEXint4
No
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDLDOMIDint4
No
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDLINKIDint4
No
RFLAGint4
Yes
Indexes Indexes
NameColumnsUnique
Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMIDUNITSEC_PKUNITID, TYPE, TYPEX, LINKID, UDOMID, LDOMID
Yes
SQL Script
CREATE TABLE [dbo].[UNITSEC]
(
[UDOMID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[TYPE] [int] NOT NULL,
[TYPEX] [int] NOT NULL,
[LDOMID] [int] NOT NULL,
[LINKID] [int] NOT NULL,
[RFLAG] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UNITSEC] ADD CONSTRAINT [UNITSEC_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [TYPE], [TYPEX], [LINKID], [UDOMID], [LDOMID]) ON [PRIMARY]
GO
Uses