[dbo].[list]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
	listid	int	4
$Indexes list_idx_01: name\owner$ $Indexes list_idx_02: owner\name$	name	varchar(255)	255
	filterid	int	4
$Indexes list_idx_01: name\owner$ $Indexes list_idx_02: owner\name$	owner	varchar(255)	255
	description	varchar(255)	255
	checkoutsid	varchar(100)	100
	checkoutname	varchar(100)	100
	psname	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

listid

int

$Indexes list_idx_01: name\owner$ $Indexes list_idx_02: owner\name$

name

varchar(255)

255

filterid

int

$Indexes list_idx_01: name\owner$ $Indexes list_idx_02: owner\name$

owner

varchar(255)

255

description

varchar(255)

255

checkoutsid

varchar(100)

100

checkoutname

varchar(100)

100

psname

varchar(255)

255

Name	Columns	Unique
baseidx_list	listid
list_idx_01	name, owner
list_idx_02	owner, name

Name

Columns

Unique

baseidx_list

listid

list_idx_01

name, owner

list_idx_02

owner, name

SQL Script

CREATE TABLE [dbo].[list]
(
[listid] [int] NOT NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[filterid] [int] NULL,
[owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS 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_list] ON [dbo].[list] ([listid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [list_idx_01] ON [dbo].[list] ([name], [owner]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [list_idx_02] ON [dbo].[list] ([owner], [name]) ON [PRIMARY]
GO