Tables [dbo].[NCIPC]
(local) > CAAMDB_EXAMPLE > Tables > dbo.NCIPC
Properties
PropertyValue
HeapYes
Row Count1
Created3:44:38 PM Friday, June 13, 2003
Last Modified3:44:38 PM Friday, June 13, 2003
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key NCIPC_PK: IPCIDIPCIDint4
No
Indexes NCIPC_SK4: IPCTYPE\IPCTYPEX\UDOMIDIPCTYPEint4
Yes
Indexes NCIPC_SK4: IPCTYPE\IPCTYPEX\UDOMIDIPCTYPEXint4
Yes
ADOMIDint4
Yes
IPCACIDint4
Yes
EDOMIDint4
Yes
IPCEXTIDint4
Yes
Indexes NCIPC_SK1: IPCSID\SDOMIDSDOMIDint4
Yes
IPCSTYPEint4
Yes
Indexes NCIPC_SK1: IPCSID\SDOMIDIPCSIDint4
Yes
Indexes NCIPC_SK4: IPCTYPE\IPCTYPEX\UDOMIDUDOMIDint4
Yes
UNITIDint4
Yes
Indexes NCIPC_SK3: IPCDATEIPCDATEint4
Yes
Indexes Indexes
NameColumnsUnique
Primary Key NCIPC_PK: IPCIDNCIPC_PKIPCID
Yes
NCIPC_SK1IPCSID, SDOMID
NCIPC_SK3IPCDATE
NCIPC_SK4IPCTYPE, IPCTYPEX, UDOMID
SQL Script
CREATE TABLE [dbo].[NCIPC]
(
[IPCID] [int] NOT NULL,
[IPCTYPE] [int] NULL,
[IPCTYPEX] [int] NULL,
[ADOMID] [int] NULL,
[IPCACID] [int] NULL,
[EDOMID] [int] NULL,
[IPCEXTID] [int] NULL,
[SDOMID] [int] NULL,
[IPCSTYPE] [int] NULL,
[IPCSID] [int] NULL,
[UDOMID] [int] NULL,
[UNITID] [int] NULL,
[IPCDATE] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCIPC] ADD CONSTRAINT [NCIPC_PK] PRIMARY KEY NONCLUSTERED ([IPCID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NCIPC_SK3] ON [dbo].[NCIPC] ([IPCDATE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NCIPC_SK1] ON [dbo].[NCIPC] ([IPCSID], [SDOMID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NCIPC_SK4] ON [dbo].[NCIPC] ([IPCTYPE], [IPCTYPEX], [UDOMID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved