[dbo].[NCEPDEF]

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

Name	Data Type	Max Length (Bytes)
EPID	int	4
EPNAME	varchar(127)	127
EPDMNAME	varchar(64)	64
EPTYPE	int	4
EPBITMSK	int	4
EPSRV	varchar(127)	127
EPDSNTYP	varchar(64)	64
EPDSN	varchar(127)	127
EPUID	varchar(64)	64
EPPWD	varchar(64)	64
EPDBTYPE	varchar(64)	64
EPDBSERV	varchar(127)	127
EPDBNAME	varchar(127)	127
EPADD	varchar(127)	127
EPMEMO	text	max

	Name	Columns	Unique
	NCEPDEF_PK	EPID
	NCEPDEF_SK1	EPNAME

SQL Script

CREATE TABLE [dbo].[NCEPDEF]
(
[EPID] [int] NOT NULL,
[EPNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDMNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPTYPE] [int] NULL,
[EPBITMSK] [int] NULL,
[EPSRV] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDSNTYP] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDSN] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPUID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPPWD] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDBTYPE] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDBSERV] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPDBNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPADD] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPMEMO] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCEPDEF] ADD CONSTRAINT [NCEPDEF_PK] PRIMARY KEY NONCLUSTERED ([EPID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [NCEPDEF_SK1] ON [dbo].[NCEPDEF] ([EPNAME]) ON [PRIMARY]
GO