[dbo].[REG_SNAPSHOT]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	1087
Created	1:08:01 AM Thursday, September 10, 2009
Last Modified	1:08:01 AM Thursday, September 10, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

1087

Created

1:08:01 AM Thursday, September 10, 2009

Last Modified

1:08:01 AM Thursday, September 10, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls	Identity
$Indexes UQ__REG_SNAPSHOT__4D94879B: REG_SNAPSHOT_ID\REG_ROOT_ID$	REG_SNAPSHOT_ID	int	4		1 - 1
$Indexes UQ__REG_SNAPSHOT__4D94879B: REG_SNAPSHOT_ID\REG_ROOT_ID$	REG_ROOT_ID	varchar(50)	50

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

$Indexes UQ__REG_SNAPSHOT__4D94879B: REG_SNAPSHOT_ID\REG_ROOT_ID$

REG_SNAPSHOT_ID

int

1 - 1

$Indexes UQ__REG_SNAPSHOT__4D94879B: REG_SNAPSHOT_ID\REG_ROOT_ID$

REG_ROOT_ID

varchar(50)

	Name	Columns	Unique
	PK__REG_SNAPSHOT__4CA06362	REG_SNAPSHOT_ID
	UQ__REG_SNAPSHOT__4D94879B	REG_SNAPSHOT_ID, REG_ROOT_ID
	REG_INDEX_SNAPSHOT_ROOT_ID	REG_ROOT_ID

Name

Columns

Unique

PK__REG_SNAPSHOT__4CA06362

REG_SNAPSHOT_ID

UQ__REG_SNAPSHOT__4D94879B

REG_SNAPSHOT_ID, REG_ROOT_ID

REG_INDEX_SNAPSHOT_ROOT_ID

REG_ROOT_ID

SQL Script

CREATE TABLE [dbo].[REG_SNAPSHOT]
(
[REG_SNAPSHOT_ID] [int] NOT NULL IDENTITY(1, 1),
[REG_ROOT_ID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_SNAPSHOT] ADD CONSTRAINT [PK__REG_SNAPSHOT__4CA06362] PRIMARY KEY CLUSTERED ([REG_SNAPSHOT_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_SNAPSHOT] ADD CONSTRAINT [UQ__REG_SNAPSHOT__4D94879B] UNIQUE NONCLUSTERED ([REG_SNAPSHOT_ID], [REG_ROOT_ID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [REG_INDEX_SNAPSHOT_ROOT_ID] ON [dbo].[REG_SNAPSHOT] ([REG_ROOT_ID]) ON [PRIMARY]
GO