Tables [dbo].[wtssroute]
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 XPKwtssroute: uuiduuidbinary(16)16
No
Indexes x_ssroute_address_x: addressaddressvarchar(25)25
No
if_indexint4
Yes
tng_uuidbinary(16)16
No
Indexes x_ssroute_next_hop_address_x: next_hop_addressnext_hop_addressvarchar(25)25
No
next_hop_if_indexint4
Yes
next_hop_tng_uuidbinary(16)16
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwtssroute: uuidXPKwtssrouteuuid
Yes
x_ssroute_address_xaddress
x_ssroute_next_hop_address_xnext_hop_address
SQL Script
CREATE TABLE [dbo].[wtssroute]
(
[uuid] [binary] (16) NOT NULL,
[address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[if_index] [int] NULL,
[tng_uuid] [binary] (16) NOT NULL,
[next_hop_address] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[next_hop_if_index] [int] NULL,
[next_hop_tng_uuid] [binary] (16) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtssroute] ADD CONSTRAINT [XPKwtssroute] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_ssroute_address_x] ON [dbo].[wtssroute] ([address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [x_ssroute_next_hop_address_x] ON [dbo].[wtssroute] ([next_hop_address]) ON [PRIMARY]
GO
Uses