[dbo].[udp]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:36 AM Wednesday, March 07, 2007
Last Modified	11:09:46 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
udpid	int	4
udpname	varchar(50)	50
prompt	varchar(255)	255
description	varchar(255)	255
datatype	smallint	2
defaultvalue	varchar(255)	255
inputstyle	smallint	2
validationtype	smallint	2
minvalue	int	4
maxvalue	int	4
errormsg	varchar(255)	255
errorcheck	varchar(255)	255
templateudp	int	4
checkoutsid	varchar(100)	100
checkoutname	varchar(100)	100
psname	varchar(255)	255

Name	Columns	Unique
baseidx_udp	udpid

SQL Script

CREATE TABLE [dbo].[udp]
(
[udpid] [int] NOT NULL,
[udpname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[prompt] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[datatype] [smallint] NULL,
[defaultvalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[inputstyle] [smallint] NULL,
[validationtype] [smallint] NULL,
[minvalue] [int] NULL,
[maxvalue] [int] NULL,
[errormsg] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[errorcheck] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[templateudp] [int] NULL,
[checkoutsid] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[checkoutname] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[psname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_udp] ON [dbo].[udp] ([udpid]) ON [PRIMARY]
GO