[dbo].[HARVERSIONINVIEW]

Property	Value
Row Count	116
Created	5:00:22 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

Property

Value

Row Count

116

Created

5:00:22 AM Monday, March 02, 2009

Last Modified

5:00:28 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$	VIEWOBJID	int	4
$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$	VERSIONOBJID	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$

VIEWOBJID

int

$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$

VERSIONOBJID

int

	Name	Columns	Unique
$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$	HARVERSIONINVIEW_PK	VIEWOBJID, VERSIONOBJID
	HARVIV_VERS_IND	VERSIONOBJID

Name

Columns

Unique

$Cluster Primary Key HARVERSIONINVIEW_PK: VIEWOBJID\VERSIONOBJID$

HARVERSIONINVIEW_PK

VIEWOBJID, VERSIONOBJID

HARVIV_VERS_IND

VERSIONOBJID

Name	Delete	Columns
HARVERSIONINVIEW_VERID_FK	Cascade	VERSIONOBJID->[dbo].[HARVERSIONS].[VERSIONOBJID]
HARVERSIONINVIEW_VIEWID_FK	Cascade	VIEWOBJID->[dbo].[HARVIEW].[VIEWOBJID]

Name

Delete

Columns

HARVERSIONINVIEW_VERID_FK

Cascade

VERSIONOBJID->[dbo].[HARVERSIONS].[VERSIONOBJID]

HARVERSIONINVIEW_VIEWID_FK

Cascade

VIEWOBJID->[dbo].[HARVIEW].[VIEWOBJID]

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARVERSIONINVIEW table stores all version activities that occur in a view, such as check-in, promote, and demote.
Caption	COLUMN	VERSIONOBJID	Version object ID
Caption	COLUMN	VIEWOBJID	Object ID of view

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARVERSIONINVIEW table stores all version activities that occur in a view, such as check-in, promote, and demote.

Caption

COLUMN

VERSIONOBJID

Version object ID

Caption

COLUMN

VIEWOBJID

Object ID of view

SQL Script

CREATE TABLE [dbo].[HARVERSIONINVIEW]
(
[VIEWOBJID] [int] NOT NULL,
[VERSIONOBJID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVERSIONINVIEW] ADD CONSTRAINT [HARVERSIONINVIEW_PK] PRIMARY KEY CLUSTERED ([VIEWOBJID], [VERSIONOBJID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [HARVIV_VERS_IND] ON [dbo].[HARVERSIONINVIEW] ([VERSIONOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARVERSIONINVIEW] ADD CONSTRAINT [HARVERSIONINVIEW_VERID_FK] FOREIGN KEY ([VERSIONOBJID]) REFERENCES [dbo].[HARVERSIONS] ([VERSIONOBJID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[HARVERSIONINVIEW] ADD CONSTRAINT [HARVERSIONINVIEW_VIEWID_FK] FOREIGN KEY ([VIEWOBJID]) REFERENCES [dbo].[HARVIEW] ([VIEWOBJID]) ON DELETE CASCADE
GO
EXEC sp_addextendedproperty N'Caption', N'The HARVERSIONINVIEW table stores all version activities that occur in a view, such as check-in, promote, and demote.', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONINVIEW', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Version object ID', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONINVIEW', 'COLUMN', N'VERSIONOBJID'
GO
EXEC sp_addextendedproperty N'Caption', N'Object ID of view', 'SCHEMA', N'dbo', 'TABLE', N'HARVERSIONINVIEW', 'COLUMN', N'VIEWOBJID'
GO