[dbo].[NCSECTOR]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1
Created	3:44:39 PM Friday, June 13, 2003
Last Modified	3:44:39 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$	DOMAINID	int	4
$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$	SCTID	int	4
	SCTNAME	varchar(50)	50
	SCTSERV	varchar(127)	127
	SCTUSER	varchar(50)	50
	SCTPWD	varchar(50)	50
	SCTPATH	varchar(128)	128
	SCTACCES	int	4
	SCTCON	int	4
	SCTCOMI	int	4
	SCTVAL	int	4
	SCTSVAL	int	4
	SCTINT	int	4
	SCTVDATE	int	4
	SCTCOM	varchar(127)	127

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$

DOMAINID

int

$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$

SCTID

int

SCTNAME

varchar(50)

SCTSERV

varchar(127)

127

SCTUSER

varchar(50)

SCTPWD

varchar(50)

SCTPATH

varchar(128)

128

SCTACCES

int

SCTCON

int

SCTCOMI

int

SCTVAL

int

SCTSVAL

int

SCTINT

int

SCTVDATE

int

SCTCOM

varchar(127)

127

	Name	Columns	Unique
$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$	NCSECTOR_PK	SCTID, DOMAINID

Name

Columns

Unique

$Cluster Primary Key NCSECTOR_PK: SCTID\DOMAINID$

NCSECTOR_PK

SCTID, DOMAINID

SQL Script

CREATE TABLE [dbo].[NCSECTOR]
(
[DOMAINID] [int] NOT NULL,
[SCTID] [int] NOT NULL,
[SCTNAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTSERV] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTUSER] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTPWD] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTPATH] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SCTACCES] [int] NULL,
[SCTCON] [int] NULL,
[SCTCOMI] [int] NULL,
[SCTVAL] [int] NULL,
[SCTSVAL] [int] NULL,
[SCTINT] [int] NULL,
[SCTVDATE] [int] NULL,
[SCTCOM] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCSECTOR] ADD CONSTRAINT [NCSECTOR_PK] PRIMARY KEY CLUSTERED ([SCTID], [DOMAINID]) ON [PRIMARY]
GO