Tables [dbo].[wtdbpvqueryinfo]
Properties
PropertyValue
Row Count0
Created12:31:45 PM Sunday, December 05, 2010
Last Modified7:26:12 PM Friday, January 07, 2011
Columns
NameData TypeCollationMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKwtdbpvqueryinfo: query_name\sequence_numbersequence_numberint4
No
Cluster Primary Key XPKwtdbpvqueryinfo: query_name\sequence_numberIndexes x_DBPVQueryInfo_x: query_namequery_namevarchar(255)SQL_Latin1_General_CP1_CI_AS255
No
identifiervarchar(255)SQL_Latin1_General_CP1_CI_AS255
No
operatorvarchar(255)SQL_Latin1_General_CP1_CI_AS255
No
attributevarchar(255)SQL_Latin1_General_CP1_CI_AS255
No
typeint4
No
valuevarchar(255)SQL_Latin1_General_CP1_CS_AS255
Yes
enabledtinyint1
No
schema_namevarchar(255)SQL_Latin1_General_CP1_CI_AS255
No
logical_opint4
Yes
reservedvarchar(255)SQL_Latin1_General_CP1_CI_AS255
Yes
weightint4
Yes
start_groupint4
Yes
end_groupint4
Yes
include_subclassestinyint1
No
((1))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtdbpvqueryinfo: query_name\sequence_numberXPKwtdbpvqueryinfoquery_name, sequence_number
Yes
x_DBPVQueryInfo_xquery_name
Permissions
TypeActionOwning Principal
GrantDeleteuniadmin
GrantInsertuniadmin
GrantDeletewvadmin
GrantInsertwvadmin
GrantSelectuniadmin
GrantUpdateuniadmin
GrantSelectuniuser
GrantSelectwvadmin
GrantUpdatewvadmin
GrantSelectwvuser
SQL Script
CREATE TABLE [dbo].[wtdbpvqueryinfo]
(
[sequence_number] [int] NOT NULL,
[query_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[identifier] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[operator] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[type] [int] NOT NULL,
[value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[enabled] [tinyint] NOT NULL,
[schema_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[logical_op] [int] NULL,
[reserved] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[weight] [int] NULL,
[start_group] [int] NULL,
[end_group] [int] NULL,
[include_subclasses] [tinyint] NOT NULL CONSTRAINT [DF__wtdbpvque__inclu__0E44D4E4] DEFAULT ((1))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[wtdbpvqueryinfo] ADD CONSTRAINT [XPKwtdbpvqueryinfo] PRIMARY KEY CLUSTERED ([query_name], [sequence_number]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_DBPVQueryInfo_x] ON [dbo].[wtdbpvqueryinfo] ([query_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT INSERT ON  [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT DELETE ON  [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT UPDATE ON  [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT SELECT ON  [dbo].[wtdbpvqueryinfo] TO [uniuser]
GRANT SELECT ON  [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT INSERT ON  [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT DELETE ON  [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT UPDATE ON  [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT SELECT ON  [dbo].[wtdbpvqueryinfo] TO [wvuser]
GO
Uses