Tables [dbo].[wtssvtpdomain]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:55 AM Wednesday, March 07, 2007
Last Modified11:09:48 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwtssvtpdomain: uuidIndexes ssvtpdomain_dx1: uuiduuidbinary(16)16
No
Indexes ssvtpdomain_dx2: namenamevarchar(200)200
Yes
descriptionvarchar(255)255
Yes
domain_indexint4
No
local_modeint4
No
server_addressvarchar(25)25
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtssvtpdomain: uuidXPKwtssvtpdomainuuid
Yes
ssvtpdomain_dx1uuid
ssvtpdomain_dx2name
SQL Script
CREATE TABLE [dbo].[wtssvtpdomain]
(
[uuid] [binary] (16) NOT NULL,
[name] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[domain_index] [int] NOT NULL,
[local_mode] [int] NOT NULL,
[server_address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtssvtpdomain] ADD CONSTRAINT [XPKwtssvtpdomain] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssvtpdomain_dx2] ON [dbo].[wtssvtpdomain] ([name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ssvtpdomain_dx1] ON [dbo].[wtssvtpdomain] ([uuid]) ON [PRIMARY]
GO
Uses