[dbo].[NCEPIPC]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

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)
EPIPCID	int	4
EPIPCTYP	int	4
EPIPCACT	int	4
EPIPCDID	int	4
EPIPCUID	int	4
EPIPCLN1	int	4
EPIPCLN2	int	4
EPIPCLN3	int	4
EPIPCLN4	int	4
EPIPCTX1	varchar(127)	127
EPIPCTX2	varchar(127)	127
EPIPCDAT	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

EPIPCID

int

EPIPCTYP

int

EPIPCACT

int

EPIPCDID

int

EPIPCUID

int

EPIPCLN1

int

EPIPCLN2

int

EPIPCLN3

int

EPIPCLN4

int

EPIPCTX1

varchar(127)

127

EPIPCTX2

varchar(127)

127

EPIPCDAT

int

	Name	Columns	Unique
	NCEPIPC_PK	EPIPCID

Name

Columns

Unique

NCEPIPC_PK

EPIPCID

SQL Script

CREATE TABLE [dbo].[NCEPIPC]
(
[EPIPCID] [int] NOT NULL,
[EPIPCTYP] [int] NULL,
[EPIPCACT] [int] NULL,
[EPIPCDID] [int] NULL,
[EPIPCUID] [int] NULL,
[EPIPCLN1] [int] NULL,
[EPIPCLN2] [int] NULL,
[EPIPCLN3] [int] NULL,
[EPIPCLN4] [int] NULL,
[EPIPCTX1] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPIPCTX2] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EPIPCDAT] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NCEPIPC] ADD CONSTRAINT [NCEPIPC_PK] PRIMARY KEY NONCLUSTERED ([EPIPCID]) ON [PRIMARY]
GO