Tables [dbo].[HARPACKAGENAMEGEN]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created5:00:01 AM Monday, March 02, 2009
Last Modified5:00:01 AM Monday, March 02, 2009
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key HARPACKAGENAMEGEN_PK: NAMEFORMATNAMEFORMATvarchar(128)128
No
NAMECOUNTERint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key HARPACKAGENAMEGEN_PK: NAMEFORMATHARPACKAGENAMEGEN_PKNAMEFORMAT
Yes
Extended Properties
NameLevel 2 TypeLevel 2 NameValue
CaptionThe HARPACKAGENAMEGEN table tracks the unique names of generated packages.
CaptionCOLUMNNAMECOUNTERNumber of times default package name with counter has been used
CaptionCOLUMNNAMEFORMATFormat of default package name
SQL Script
CREATE TABLE [dbo].[HARPACKAGENAMEGEN]
(
[NAMEFORMAT] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NAMECOUNTER] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPACKAGENAMEGEN] ADD CONSTRAINT [HARPACKAGENAMEGEN_PK] PRIMARY KEY CLUSTERED ([NAMEFORMAT]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPACKAGENAMEGEN table tracks the unique names of generated packages.', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGENAMEGEN', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Number of times default package name with counter has been used', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGENAMEGEN', 'COLUMN', N'NAMECOUNTER'
GO
EXEC sp_addextendedproperty N'Caption', N'Format of default package name', 'SCHEMA', N'dbo', 'TABLE', N'HARPACKAGENAMEGEN', 'COLUMN', N'NAMEFORMAT'
GO
Uses