Tables [dbo].[APPLINK]
(local) > CAAMDB_EXAMPLE > Tables > dbo.APPLINK
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count4610
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 APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDUDOMIDint4
No
Primary Key APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDCluster Key APPLINK_SK1: UNITIDUNITIDint4
No
Primary Key APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDADOMIDint4
No
Primary Key APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDAPIDint4
No
Primary Key APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDAPCOUNTint4
No
PATHvarchar(127)127
Yes
FILENAMEvarchar(127)127
Yes
Indexes Indexes
NameColumnsUnique
Primary Key APPLINK_PK: UNITID\APID\APCOUNT\UDOMID\ADOMIDAPPLINK_PKUNITID, APID, APCOUNT, UDOMID, ADOMID
Yes
Cluster Key APPLINK_SK1: UNITIDAPPLINK_SK1UNITID
SQL Script
CREATE TABLE [dbo].[APPLINK]
(
[UDOMID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[ADOMID] [int] NOT NULL,
[APID] [int] NOT NULL,
[APCOUNT] [int] NOT NULL,
[PATH] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FILENAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APPLINK] ADD CONSTRAINT [APPLINK_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [APID], [APCOUNT], [UDOMID], [ADOMID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [APPLINK_SK1] ON [dbo].[APPLINK] ([UNITID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved