Tables [dbo].[wturm]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created12:31:54 PM Sunday, December 05, 2010
Last Modified12:31:54 PM Sunday, December 05, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKwturm: uuiduuidbinary(16)16
No
urm_resourcevarchar(246)246
Yes
urm_agentvarchar(246)246
Yes
urm_alarmmsgvarchar(246)246
Yes
('')
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwturm: uuidXPKwturmuuid
Yes
SQL Script
CREATE TABLE [dbo].[wturm]
(
[uuid] [binary] (16) NOT NULL,
[urm_resource] [varchar] (246) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[urm_agent] [varchar] (246) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[urm_alarmmsg] [varchar] (246) COLLATE SQL_Latin1_General_CP1_CS_AS NULL CONSTRAINT [DF__wturm__urm_alarm__48C67C34] DEFAULT ('')
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[wturm] ADD CONSTRAINT [XPKwturm] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
Uses
Used By