[dbo].[analysis]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Heap

Row Count

Created

11:06:59 AM Wednesday, March 07, 2007

Last Modified

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

	Name	Data Type	Max Length (Bytes)
	analysisid	int	4
$Indexes analysis_idx_01: name\owner$ $Indexes analysis_idx_02: owner\name$	name	varchar(255)	255
$Indexes analysis_idx_01: name\owner$ $Indexes analysis_idx_02: owner\name$	owner	varchar(255)	255
	propertytype	int	4
	propertyid	int	4
	filterid	int	4
	listtype	int	4
	matchestype	int	4
	casesensitive	int	4
	usebasecolor	int	4
	basecolor	int	4
	checkoutsid	varchar(100)	100
	checkoutname	varchar(100)	100
	psname	varchar(255)	255
	altpropid	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

analysisid

int

$Indexes analysis_idx_01: name\owner$ $Indexes analysis_idx_02: owner\name$

name

varchar(255)

255

$Indexes analysis_idx_01: name\owner$ $Indexes analysis_idx_02: owner\name$

owner

varchar(255)

255

propertytype

int

propertyid

int

filterid

int

listtype

int

matchestype

int

casesensitive

int

usebasecolor

int

basecolor

int

checkoutsid

varchar(100)

100

checkoutname

varchar(100)

100

psname

varchar(255)

255

altpropid

int

Name	Columns	Unique
analysis_idx_01	name, owner
analysis_idx_02	owner, name
baseidx_analysis	analysisid

Name

Columns

Unique

analysis_idx_01

name, owner

analysis_idx_02

owner, name

baseidx_analysis

analysisid

SQL Script

CREATE TABLE [dbo].[analysis]
(
[analysisid] [int] NOT NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[owner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[propertytype] [int] NOT NULL,
[propertyid] [int] NULL,
[filterid] [int] NULL,
[listtype] [int] NULL,
[matchestype] [int] NULL,
[casesensitive] [int] NULL,
[usebasecolor] [int] NULL,
[basecolor] [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,
[altpropid] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_analysis] ON [dbo].[analysis] ([analysisid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [analysis_idx_01] ON [dbo].[analysis] ([name], [owner]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [analysis_idx_02] ON [dbo].[analysis] ([owner], [name]) ON [PRIMARY]
GO