[dbo].[HAROBJECTSEQUENCEID]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	17
Created	4:59:59 AM Monday, March 02, 2009
Last Modified	4:59:59 AM Monday, March 02, 2009

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	HARTABLENAME	varchar(64)	64
	HARSEQUENCEID	varchar(64)	64

	Name	Columns	Unique
	HAROBJECTSEQUENCEID_PK	HARTABLENAME

Name	Level 2 Type	Level 2 Name	Value
Caption			The HAROBJECTSEQUENCEID table contains a list of the tables that use sequences and the corresponding name of the sequence they use.
Caption	COLUMN	HARSEQUENCEID	Sequence name
Caption	COLUMN	HARTABLENAME	CA SCM table name

SQL Script

CREATE TABLE [dbo].[HAROBJECTSEQUENCEID]
(
[HARTABLENAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[HARSEQUENCEID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HAROBJECTSEQUENCEID] ADD CONSTRAINT [HAROBJECTSEQUENCEID_PK] PRIMARY KEY CLUSTERED ([HARTABLENAME]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HAROBJECTSEQUENCEID table contains a list of the tables that use sequences and the corresponding name of the sequence they use. ', 'SCHEMA', N'dbo', 'TABLE', N'HAROBJECTSEQUENCEID', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Sequence name', 'SCHEMA', N'dbo', 'TABLE', N'HAROBJECTSEQUENCEID', 'COLUMN', N'HARSEQUENCEID'
GO
EXEC sp_addextendedproperty N'Caption', N'CA SCM table name', 'SCHEMA', N'dbo', 'TABLE', N'HAROBJECTSEQUENCEID', 'COLUMN', N'HARTABLENAME'
GO