[dbo].[wteauditmessagegroup]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CS_AS

Row Count

Created

11:07:51 AM Wednesday, March 07, 2007

Last Modified

11:09:18 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
name	varchar(30)	30
description	varchar(255)	255
owner	varchar(32)	32
priority	int	4
pending	tinyint	1
pendingid	varchar(32)	32
viewerprofile	varchar(128)	128
annotated	tinyint	1

Name

Data Type

Max Length (Bytes)

Allow Nulls

name

varchar(30)

description

varchar(255)

255

owner

varchar(32)

priority

int

pending

tinyint

pendingid

varchar(32)

viewerprofile

varchar(128)

128

annotated

tinyint

	Name	Columns	Unique
	XPKwteauditmessagegroup	name

Name

Columns

Unique

XPKwteauditmessagegroup

name

SQL Script

CREATE TABLE [dbo].[wteauditmessagegroup]
(
[name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [int] NULL,
[pending] [tinyint] NULL,
[pendingid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[viewerprofile] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[annotated] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wteauditmessagegroup] ADD CONSTRAINT [XPKwteauditmessagegroup] PRIMARY KEY CLUSTERED ([name]) ON [PRIMARY]
GO