[dbo].[HARPMSTATUS]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	7
Created	5:00:04 AM Monday, March 02, 2009
Last Modified	5:00:28 AM Monday, March 02, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	PMSTATUSINDEX	int	4
	PMSTATUSNAME	varchar(128)	128

Name

Data Type

Max Length (Bytes)

Allow Nulls

PMSTATUSINDEX

int

PMSTATUSNAME

varchar(128)

128

	Name	Columns	Unique
	HARPMSTATUS_PK	PMSTATUSINDEX

Name

Columns

Unique

HARPMSTATUS_PK

PMSTATUSINDEX

Name	Level 2 Type	Level 2 Name	Value
Caption			The HARPMSTATUS table.
Caption	COLUMN	PMSTATUSINDEX	Status Index
Caption	COLUMN	PMSTATUSNAME	Status Name

Name

Level 2 Type

Level 2 Name

Value

Caption

The HARPMSTATUS table.

Caption

COLUMN

PMSTATUSINDEX

Status Index

Caption

COLUMN

PMSTATUSNAME

Status Name

SQL Script

CREATE TABLE [dbo].[HARPMSTATUS]
(
[PMSTATUSINDEX] [int] NOT NULL,
[PMSTATUSNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARPMSTATUS] ADD CONSTRAINT [HARPMSTATUS_PK] PRIMARY KEY CLUSTERED ([PMSTATUSINDEX]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'Caption', N'The HARPMSTATUS table. ', 'SCHEMA', N'dbo', 'TABLE', N'HARPMSTATUS', NULL, NULL
GO
EXEC sp_addextendedproperty N'Caption', N'Status Index', 'SCHEMA', N'dbo', 'TABLE', N'HARPMSTATUS', 'COLUMN', N'PMSTATUSINDEX'
GO
EXEC sp_addextendedproperty N'Caption', N'Status Name', 'SCHEMA', N'dbo', 'TABLE', N'HARPMSTATUS', 'COLUMN', N'PMSTATUSNAME'
GO