[dbo].[REG_DEPENDENCY]

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

690

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

Name

Data Type

Max Length (Bytes)

Allow Nulls

Identity

REG_DEPENDENCY_ID

int

1 - 1

$Indexes UQ__REG_DEPENDENCY__30F848ED: REG_PARENT_RID\REG_CHILD_RID$

REG_PARENT_RID

varchar(50)

$Indexes UQ__REG_DEPENDENCY__30F848ED: REG_PARENT_RID\REG_CHILD_RID$

REG_CHILD_RID

varchar(50)

	Name	Columns	Unique
	PK__REG_DEPENDENCY__300424B4	REG_DEPENDENCY_ID
	UQ__REG_DEPENDENCY__30F848ED	REG_PARENT_RID, REG_CHILD_RID

Name

Columns

Unique

PK__REG_DEPENDENCY__300424B4

REG_DEPENDENCY_ID

UQ__REG_DEPENDENCY__30F848ED

REG_PARENT_RID, REG_CHILD_RID

Name	Delete	Columns
FK__REG_DEPEN__REG_C__32E0915F		REG_CHILD_RID->[dbo].[REG_RESOURCE].[REG_RID]
FK__REG_DEPEN__REG_P__31EC6D26	Cascade	REG_PARENT_RID->[dbo].[REG_RESOURCE].[REG_RID]

Name

Delete

Columns

FK__REG_DEPEN__REG_C__32E0915F

REG_CHILD_RID->[dbo].[REG_RESOURCE].[REG_RID]

FK__REG_DEPEN__REG_P__31EC6D26

Cascade

REG_PARENT_RID->[dbo].[REG_RESOURCE].[REG_RID]

SQL Script

CREATE TABLE [dbo].[REG_DEPENDENCY]
(
[REG_DEPENDENCY_ID] [int] NOT NULL IDENTITY(1, 1),
[REG_PARENT_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[REG_CHILD_RID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_DEPENDENCY] ADD CONSTRAINT [PK__REG_DEPENDENCY__300424B4] PRIMARY KEY CLUSTERED ([REG_DEPENDENCY_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_DEPENDENCY] ADD CONSTRAINT [UQ__REG_DEPENDENCY__30F848ED] UNIQUE NONCLUSTERED ([REG_PARENT_RID], [REG_CHILD_RID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[REG_DEPENDENCY] ADD CONSTRAINT [FK__REG_DEPEN__REG_C__32E0915F] FOREIGN KEY ([REG_CHILD_RID]) REFERENCES [dbo].[REG_RESOURCE] ([REG_RID])
GO
ALTER TABLE [dbo].[REG_DEPENDENCY] ADD CONSTRAINT [FK__REG_DEPEN__REG_P__31EC6D26] FOREIGN KEY ([REG_PARENT_RID]) REFERENCES [dbo].[REG_RESOURCE] ([REG_RID]) ON DELETE CASCADE
GO