[dbo].[UNITSEC]

(local) > CAAMDB_EXAMPLE > Tables > dbo.UNITSEC

Properties
Columns
Indexes
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	3:44:42 PM Friday, June 13, 2003
Last Modified	3:44:42 PM Friday, June 13, 2003

Columns

	Name	Data Type	Max Length (Bytes)
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	UDOMID	int	4
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	UNITID	int	4
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	TYPE	int	4
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	TYPEX	int	4
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	LDOMID	int	4
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	LINKID	int	4
	RFLAG	int	4

Indexes

	Name	Columns	Unique
$Primary Key UNITSEC_PK: UNITID\TYPE\TYPEX\LINKID\UDOMID\LDOMID$	UNITSEC_PK	UNITID, TYPE, TYPEX, LINKID, UDOMID, LDOMID

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