[dbo].[REG_DEPENDENCY

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
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

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_DEPENDENCY_VERSION_ID	int	4	1 - 1
$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$	REG_PARENT_RID	varchar(50)	50
$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$	REG_PARENT_VERSION	int	4
$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$	REG_CHILD_RID	varchar(50)	50

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

REG_DEPENDENCY_VERSION_ID

int

1 - 1

$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$

REG_PARENT_RID

varchar(50)

$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$

REG_PARENT_VERSION

int

$Indexes UQ__REG_DEPENDENCY_V__47DBAE45: REG_PARENT_RID\REG_PARENT_VERSION\REG_CHILD_RID$

REG_CHILD_RID

varchar(50)

	Name	Columns	Unique
	PK__REG_DEPENDENCY_V__46E78A0C	REG_DEPENDENCY_VERSION_ID
	UQ__REG_DEPENDENCY_V__47DBAE45	REG_PARENT_RID, REG_PARENT_VERSION, REG_CHILD_RID

Name

Columns

Unique

PK__REG_DEPENDENCY_V__46E78A0C

REG_DEPENDENCY_VERSION_ID

UQ__REG_DEPENDENCY_V__47DBAE45

REG_PARENT_RID, REG_PARENT_VERSION, REG_CHILD_RID

SQL Script

CREATE TABLE [dbo].[REG_DEPENDENCY_VERSION]
(
[REG_DEPENDENCY_VERSION_ID] [int] NOT NULL IDENTITY(1, 1),
[REG_PARENT_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_PARENT_VERSION] [int] NOT NULL,
[REG_CHILD_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_DEPENDENCY_VERSION] ADD CONSTRAINT [PK__REG_DEPENDENCY_V__46E78A0C] PRIMARY KEY CLUSTERED ([REG_DEPENDENCY_VERSION_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_DEPENDENCY_VERSION] ADD CONSTRAINT [UQ__REG_DEPENDENCY_V__47DBAE45] UNIQUE NONCLUSTERED ([REG_PARENT_RID], [REG_PARENT_VERSION], [REG_CHILD_RID]) ON [PRIMARY]
GO