Tables [dbo].[wteauditmessagegroupmessage]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:51 AM Wednesday, March 07, 2007
Last Modified11:07:51 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
messagegroupnamevarchar(30)30
No
collectornodevarchar(32)32
No
collectortablevarchar(32)32
No
collectoridint4
No
timestampvarchar(30)30
No
ownervarchar(32)32
Yes
priorityint4
Yes
pendingtinyint1
Yes
annotatedtinyint1
Yes
pendingidvarchar(32)32
Yes
columns1varchar(255)255
Yes
columns2varchar(255)255
Yes
columns3varchar(255)255
Yes
columns4varchar(255)255
Yes
columns5varchar(255)255
Yes
columns6varchar(255)255
Yes
columns7varchar(255)255
Yes
columns8varchar(255)255
Yes
columns9varchar(255)255
Yes
columns10varchar(255)255
Yes
columns11varchar(255)255
Yes
columns12varchar(255)255
Yes
SQL Script
CREATE TABLE [dbo].[wteauditmessagegroupmessage]
(
[messagegroupname] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[collectornode] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[collectortable] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[collectorid] [int] NOT NULL,
[timestamp] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[owner] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [int] NULL,
[pending] [tinyint] NULL,
[annotated] [tinyint] NULL,
[pendingid] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns5] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns6] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns7] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns8] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns9] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns10] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns11] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[columns12] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
Uses