[dbo].[REG_SNAPSHOT_RESOURCE

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)	Identity
	REG_SRV_ID	int	4	1 - 1
$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$	REG_SNAPSHOT_ID	int	4
$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$	REG_RID	varchar(50)	50
$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$	REG_VERSION	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

REG_SRV_ID

int

1 - 1

$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$

REG_SNAPSHOT_ID

int

$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$

REG_RID

varchar(50)

$Indexes UQ__REG_SNAPSHOT_RES__5070F446: REG_SNAPSHOT_ID\REG_RID\REG_VERSION$

REG_VERSION

int

	Name	Columns	Unique
	PK__REG_SNAPSHOT_RES__4F7CD00D	REG_SRV_ID
	UQ__REG_SNAPSHOT_RES__5070F446	REG_SNAPSHOT_ID, REG_RID, REG_VERSION

Name

Columns

Unique

PK__REG_SNAPSHOT_RES__4F7CD00D

REG_SRV_ID

UQ__REG_SNAPSHOT_RES__5070F446

REG_SNAPSHOT_ID, REG_RID, REG_VERSION

SQL Script

CREATE TABLE [dbo].[REG_SNAPSHOT_RESOURCE_VERSION]
(
[REG_SRV_ID] [int] NOT NULL IDENTITY(1, 1),
[REG_SNAPSHOT_ID] [int] NOT NULL,
[REG_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_VERSION] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_SNAPSHOT_RESOURCE_VERSION] ADD CONSTRAINT [PK__REG_SNAPSHOT_RES__4F7CD00D] PRIMARY KEY CLUSTERED ([REG_SRV_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_SNAPSHOT_RESOURCE_VERSION] ADD CONSTRAINT [UQ__REG_SNAPSHOT_RES__5070F446] UNIQUE NONCLUSTERED ([REG_SNAPSHOT_ID], [REG_RID], [REG_VERSION]) ON [PRIMARY]
GO