[dbo].[APPDEF]

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key APPDEF_PK: APID\DOMAINID$	DOMAINID	int	4
$Cluster Primary Key APPDEF_PK: APID\DOMAINID$	APID	int	4
	APTITLE	varchar(64)	64
	APFNAME	varchar(127)	127
	APFMNAME	varchar(64)	64
	APMAIN	int	4
	PUBID	int	4
	PLID	int	4
	FLAG	int	4
	OPTION1	varchar(127)	127
	OPTION2	varchar(127)	127
	OPTION3	varchar(127)	127
	APBIN	text	max
	Y2000	int	4
	sql_tstamp	timestamp	8

	Name	Columns
$Cluster Primary Key APPDEF_PK: APID\DOMAINID$	APPDEF_PK	APID, DOMAINID
	APPDEF_SK1	APTITLE
	APPDEF_SK2	PLID
	APPDEF_SK3	PUBID

SQL Script

CREATE TABLE [dbo].[APPDEF]
(
[DOMAINID] [int] NOT NULL,
[APID] [int] NOT NULL,
[APTITLE] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APFNAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APFMNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APMAIN] [int] NULL,
[PUBID] [int] NULL,
[PLID] [int] NULL,
[FLAG] [int] NULL,
[OPTION1] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPTION2] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OPTION3] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[APBIN] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Y2000] [int] NULL,
[sql_tstamp] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[APPDEF] ADD CONSTRAINT [APPDEF_PK] PRIMARY KEY CLUSTERED ([APID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [APPDEF_SK1] ON [dbo].[APPDEF] ([APTITLE]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [APPDEF_SK2] ON [dbo].[APPDEF] ([PLID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [APPDEF_SK3] ON [dbo].[APPDEF] ([PUBID]) ON [PRIMARY]
GO