Tables [dbo].[wtdbpvqueryinfo]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:35:33 AM Wednesday, March 07, 2007
Last Modified5:40:13 PM Monday, May 04, 2009
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKwtdbpvqueryinfo: query_name\sequence_numbersequence_numberint4
No
Cluster Primary Key XPKwtdbpvqueryinfo: query_name\sequence_numberquery_namevarchar(255)255
No
identifiervarchar(255)255
No
operatorvarchar(255)255
No
attributevarchar(255)255
No
typeint4
No
valuevarchar(255)255
Yes
enabledtinyint1
No
schema_namevarchar(255)255
No
logical_opint4
Yes
reservedvarchar(255)255
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
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_CI_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
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