[dbo].[wtanodevice]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:47 AM Wednesday, March 07, 2007
Last Modified	11:09:48 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
name	varchar(200)	200
uuid	binary(16)	16
address	varchar(30)	30
tng_class	varchar(30)	30
tng_uuid	binary(16)	16
prop_status	int	4
deletion	tinyint	1
class_name	varchar(40)	40
atm	tinyint	1
fro	tinyint	1
rmo	tinyint	1
smo	tinyint	1
ip	tinyint	1
dsl	tinyint	1
bgp	tinyint	1
ospf	tinyint	1
p1	tinyint	1
p2	tinyint	1
p3	tinyint	1
p4	tinyint	1
p5	tinyint	1

	Name	Columns	Unique
	XPKwtanodevice	address
	sanodevice_dx1	name

SQL Script

CREATE TABLE [dbo].[wtanodevice]
(
[name] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uuid] [binary] (16) NOT NULL,
[address] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[tng_class] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tng_uuid] [binary] (16) NULL,
[prop_status] [int] NULL,
[deletion] [tinyint] NULL,
[class_name] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[atm] [tinyint] NULL,
[fro] [tinyint] NULL,
[rmo] [tinyint] NULL,
[smo] [tinyint] NULL,
[ip] [tinyint] NULL,
[dsl] [tinyint] NULL,
[bgp] [tinyint] NULL,
[ospf] [tinyint] NULL,
[p1] [tinyint] NULL,
[p2] [tinyint] NULL,
[p3] [tinyint] NULL,
[p4] [tinyint] NULL,
[p5] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtanodevice] ADD CONSTRAINT [XPKwtanodevice] PRIMARY KEY CLUSTERED ([address]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [sanodevice_dx1] ON [dbo].[wtanodevice] ([name]) ON [PRIMARY]
GO