[dbo].[wsptbl]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:07:46 AM Wednesday, March 07, 2007
Last Modified	9:09:07 PM Friday, December 05, 2008

	Name	Data Type	Max Length (Bytes)
	id	int	4
	persid	nvarchar(30)	60
$Indexes wsptbl_x1: table_name\status$	table_name	nvarchar(40)	80
$Indexes wsptbl_x1: table_name\status$	status	int	4
	schema_name	nvarchar(40)	80
	dbms_name	nvarchar(40)	80
	description	nvarchar(300)	600
	display_name	nvarchar(80)	160
	display_group	nvarchar(40)	80
	function_group	nvarchar(40)	80
	rel_attr	nvarchar(40)	80
	common_name	nvarchar(40)	80
	sort_by	nvarchar(150)	300
	methods	nvarchar(500)	1000
	triggers	ntext	max
	is_local	int	4
	is_wsp	int	4
	last_mod_dt	int	4
	last_mod_by	binary(16)	16
	table_type	int	4
	tenancy_type	int	4

	Name	Columns	Unique
	XPKwsptbl	id
	wsptbl_x1	table_name, status

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

SQL Script

CREATE TABLE [dbo].[wsptbl]
(
[id] [int] NOT NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[table_name] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[status] [int] NOT NULL,
[schema_name] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbms_name] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[display_name] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[display_group] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[function_group] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rel_attr] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[common_name] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[sort_by] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[methods] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[triggers] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[is_local] [int] NULL,
[is_wsp] [int] NULL,
[last_mod_dt] [int] NULL,
[last_mod_by] [binary] (16) NULL,
[table_type] [int] NULL,
[tenancy_type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsptbl] ADD CONSTRAINT [XPKwsptbl] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [wsptbl_x1] ON [dbo].[wsptbl] ([table_name], [status]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wsptbl] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[wsptbl] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[wsptbl] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[wsptbl] TO [service_desk_admin_group]
GO