[dbo].[udpvalues]

[dbo].[udpvalues]

Properties
Columns
Indexes
SQL Script
Uses

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

Columns

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

Indexes

Name	Columns	Unique
baseidx_udpvalues	objectid, udpid, instanceid

SQL Script

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

Uses