[dbo].[templateudpvalues]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:07:33 AM Wednesday, March 07, 2007

Last Modified

11:09:45 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$	templateid	int	4
$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$	udpid	int	4
$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$	objectid	int	4
$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$	instanceid	int	4
	strvalue	varchar(1)	1
	textvalue	varchar(1)	1
	intvalue	varchar(1)	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$

templateid

int

$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$

udpid

int

$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$

objectid

int

$Indexes baseidx_templateudpvalues: templateid\udpid\objectid\instanceid$

instanceid

int

strvalue

varchar(1)

textvalue

varchar(1)

intvalue

varchar(1)

Name	Columns	Unique
baseidx_templateudpvalues	templateid, udpid, objectid, instanceid

Name

Columns

Unique

baseidx_templateudpvalues

templateid, udpid, objectid, instanceid

SQL Script

CREATE TABLE [dbo].[templateudpvalues]
(
[templateid] [int] NOT NULL,
[udpid] [int] NOT NULL,
[objectid] [int] NOT NULL,
[instanceid] [int] NOT NULL,
[strvalue] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[textvalue] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[intvalue] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_templateudpvalues] ON [dbo].[templateudpvalues] ([templateid], [udpid], [objectid], [instanceid]) ON [PRIMARY]
GO