[dbo].[NCTNGREF]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

3:44:40 PM Friday, June 13, 2003

Last Modified

3:44:40 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Primary Key NCTNGREF_PK: UNITID\DOMAINID$	DOMAINID	int	4
$Primary Key NCTNGREF_PK: UNITID\DOMAINID$	UNITID	int	4
	UNITTYPE	int	4
	SEARCH1	varchar(64)	64
	SEARCH2	varchar(64)	64
	SEARCH3	varchar(64)	64
	SEARCH4	int	4
	CLSNAME	varchar(64)	64
	UUID	varchar(64)	64

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key NCTNGREF_PK: UNITID\DOMAINID$

DOMAINID

int

$Primary Key NCTNGREF_PK: UNITID\DOMAINID$

UNITID

int

UNITTYPE

int

SEARCH1

varchar(64)

SEARCH2

varchar(64)

SEARCH3

varchar(64)

SEARCH4

int

CLSNAME

varchar(64)

UUID

varchar(64)

	Name	Columns	Unique
$Primary Key NCTNGREF_PK: UNITID\DOMAINID$	NCTNGREF_PK	UNITID, DOMAINID
	NCTNGREF_SK1	UUID

Name

Columns

Unique

$Primary Key NCTNGREF_PK: UNITID\DOMAINID$

NCTNGREF_PK

UNITID, DOMAINID

NCTNGREF_SK1

UUID

SQL Script

CREATE TABLE [dbo].[NCTNGREF]
(
[DOMAINID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[UNITTYPE] [int] NULL,
[SEARCH1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEARCH2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEARCH3] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SEARCH4] [int] NULL,
[CLSNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UUID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCTNGREF] ADD CONSTRAINT [NCTNGREF_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [NCTNGREF_SK1] ON [dbo].[NCTNGREF] ([UUID]) ON [PRIMARY]
GO