[dbo].[udpselectionvalues]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

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)
$Indexes baseidx_udpselectionvalues: udpid\selectionvalue$ $Indexes udpselectionvalues_idx_01: udpid\valueid$	udpid	int	4
$Indexes baseidx_udpselectionvalues: udpid\selectionvalue$	selectionvalue	varchar(255)	255
	mappedvalue	varchar(255)	255
$Indexes udpselectionvalues_idx_01: udpid\valueid$	valueid	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Indexes baseidx_udpselectionvalues: udpid\selectionvalue$ $Indexes udpselectionvalues_idx_01: udpid\valueid$

udpid

int

$Indexes baseidx_udpselectionvalues: udpid\selectionvalue$

selectionvalue

varchar(255)

255

mappedvalue

varchar(255)

255

$Indexes udpselectionvalues_idx_01: udpid\valueid$

valueid

int

Name	Columns	Unique
baseidx_udpselectionvalues	udpid, selectionvalue
udpselectionvalues_idx_01	udpid, valueid

Name

Columns

Unique

baseidx_udpselectionvalues

udpid, selectionvalue

udpselectionvalues_idx_01

udpid, valueid

SQL Script

CREATE TABLE [dbo].[udpselectionvalues]
(
[udpid] [int] NOT NULL,
[selectionvalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[mappedvalue] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[valueid] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_udpselectionvalues] ON [dbo].[udpselectionvalues] ([udpid], [selectionvalue]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [udpselectionvalues_idx_01] ON [dbo].[udpselectionvalues] ([udpid], [valueid]) ON [PRIMARY]
GO