[dbo].[UNIT]

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

	Name	Data Type	Max Length (Bytes)
$Primary Key UNIT_PK: UNITID\DOMAINID$	DOMAINID	int	4
$Primary Key UNIT_PK: UNITID\DOMAINID$	UNITID	int	4
$Indexes UNIT_SK1: NAME\AREA\TYPE$	AREA	varchar(64)	64
$Indexes UNIT_SK1: NAME\AREA\TYPE$	NAME	varchar(64)	64
$Indexes UNIT_SK1: NAME\AREA\TYPE$	TYPE	int	4
$Indexes UNIT_SK2: FILEID\SECTORID$	FILEID	varchar(8)	8
	UNLEVEL	int	4
$Indexes UNIT_SK2: FILEID\SECTORID$	SECTORID	int	4
	ATTRIB	varchar(10)	10
	SCTTYPE	int	4
	CHANGES	int	4
	UNLOCK	int	4
	LRUNDATE	int	4
	EXTTYPE	int	4
	REVNR	int	4
	DMUUID	varchar(64)	64
	KEYIDEN1	varchar(64)	64
	KEYIDEN2	varchar(64)	64
	KEYIDEN3	varchar(64)	64
	KEYIDEN4	varchar(64)	64

	Name	Columns
$Primary Key UNIT_PK: UNITID\DOMAINID$	UNIT_PK	UNITID, DOMAINID
	UNIT_SK1	NAME, AREA, TYPE
	UNIT_SK2	FILEID, SECTORID

SQL Script

CREATE TABLE [dbo].[UNIT]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[AREA] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TYPE] [int] NULL,
[FILEID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UNLEVEL] [int] NULL,
[SECTORID] [int] NULL,
[ATTRIB] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTTYPE] [int] NULL,
[CHANGES] [int] NULL,
[UNLOCK] [int] NULL,
[LRUNDATE] [int] NULL,
[EXTTYPE] [int] NULL,
[REVNR] [int] NULL,
[DMUUID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEYIDEN1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEYIDEN2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEYIDEN3] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[KEYIDEN4] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UNIT] ADD CONSTRAINT [UNIT_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [UNIT_SK2] ON [dbo].[UNIT] ([FILEID], [SECTORID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [UNIT_SK1] ON [dbo].[UNIT] ([NAME], [AREA], [TYPE]) ON [PRIMARY]
GO