[dbo].[HARONDEMANDCR]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	4:59:59 AM Monday, March 02, 2009
Last Modified	5:00:26 AM Monday, March 02, 2009

Name	Data Type	Max Length (Bytes)
FORMOBJID	int	4
HODSUMMARY	varchar(256)	256
HODDATE	datetime	8
HODREQUESTER	varchar(40)	40
HODDESC	varchar(2000)	2000
HODPROJECT	varchar(128)	128
HODTEMPLATE	varchar(30)	30
HODREPNAME	varchar(128)	128
HODPRJUG	varchar(3)	3
HODEXISTPRJ	varchar(3)	3
HODSRCREP	varchar(50)	50
HODSTATE	varchar(128)	128
HODSNAPSHOT	varchar(128)	128
HODREPOPT	varchar(8)	8
HODUSRSEL	varchar(40)	40
HODUGLIST	varchar(2000)	2000

	Name	Columns	Unique
	HONDEMANDCR_PK	FORMOBJID

Name	Delete	Columns
HARONDEMANDCR_FK	Cascade	FORMOBJID->[dbo].[HARFORM].[FORMOBJID]

SQL Script

CREATE TABLE [dbo].[HARONDEMANDCR]
(
[FORMOBJID] [int] NOT NULL,
[HODSUMMARY] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODDATE] [datetime] NULL,
[HODREQUESTER] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODDESC] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODPROJECT] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODTEMPLATE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODREPNAME] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODPRJUG] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODEXISTPRJ] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODSRCREP] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODSTATE] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODSNAPSHOT] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODREPOPT] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODUSRSEL] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HODUGLIST] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARONDEMANDCR] ADD CONSTRAINT [HONDEMANDCR_PK] PRIMARY KEY CLUSTERED ([FORMOBJID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HARONDEMANDCR] ADD CONSTRAINT [HARONDEMANDCR_FK] FOREIGN KEY ([FORMOBJID]) REFERENCES [dbo].[HARFORM] ([FORMOBJID]) ON DELETE CASCADE
GO