Tables [dbo].[wturm]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:56 AM Wednesday, March 07, 2007
Last Modified11:09:48 AM Wednesday, March 07, 2007
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