[dbo].[das_anlydef]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:10 AM Wednesday, March 07, 2007
Last Modified	11:09:08 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
anlydefid	decimal(10,0)	9
productcode	varchar(255)	255
servertype	char(1)	1
category	varchar(255)	255
reporttype	varchar(255)	255
defaultseverity	int	4
description	varchar(255)	255

	Name	Columns	Unique
	das_anlydefpkey	anlydefid

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[das_anlydef]
(
[anlydefid] [decimal] (10, 0) NOT NULL,
[productcode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[servertype] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[category] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[reporttype] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defaultseverity] [int] NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[das_anlydef] ADD CONSTRAINT [das_anlydefpkey] PRIMARY KEY CLUSTERED ([anlydefid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[das_anlydef] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[das_anlydef] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[das_anlydef] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[das_anlydef] TO [udmadmin_group]
GO