Tables [dbo].[APPAPPR]
Properties
PropertyValue
HeapYes
Row Count0
Created3:44:34 PM Friday, June 13, 2003
Last Modified3:44:34 PM Friday, June 13, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key APPAPPR_PK: APID\MOID\MDOMID\ADOMIDMDOMIDint4
No
Primary Key APPAPPR_PK: APID\MOID\MDOMID\ADOMIDMOIDint4
No
Primary Key APPAPPR_PK: APID\MOID\MDOMID\ADOMIDADOMIDint4
No
Primary Key APPAPPR_PK: APID\MOID\MDOMID\ADOMIDAPIDint4
No
APPROVEDint4
Yes
Indexes Indexes
NameColumnsUnique
Primary Key APPAPPR_PK: APID\MOID\MDOMID\ADOMIDAPPAPPR_PKAPID, MOID, MDOMID, ADOMID
Yes
SQL Script
CREATE TABLE [dbo].[APPAPPR]
(
[MDOMID] [int] NOT NULL,
[MOID] [int] NOT NULL,
[ADOMID] [int] NOT NULL,
[APID] [int] NOT NULL,
[APPROVED] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APPAPPR] ADD CONSTRAINT [APPAPPR_PK] PRIMARY KEY NONCLUSTERED ([APID], [MOID], [MDOMID], [ADOMID]) ON [PRIMARY]
GO
Uses