[dbo].[wtatm_interface]

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:16 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
uuid	binary(16)	16
pollset_name	varchar(30)	30
interface_no	int	4
ifalias	varchar(100)	100
interface_level	int	4
interface_descr	varchar(30)	30
physical_descr	varchar(30)	30
atmtype	int	4
hostname	varchar(30)	30
ref_wvid	varchar(255)	255
myifname	varchar(30)	30
network_address_hex	binary(4)	4
atm_link_uuid	binary(16)	16
link_details	varchar(255)	255
nature	varchar(30)	30

	Name	Columns	Unique
	XPKwtatm_interface	uuid

SQL Script

CREATE TABLE [dbo].[wtatm_interface]
(
[uuid] [binary] (16) NOT NULL,
[pollset_name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interface_no] [int] NULL,
[ifalias] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[interface_level] [int] NULL,
[interface_descr] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[physical_descr] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[atmtype] [int] NULL,
[hostname] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ref_wvid] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[myifname] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[network_address_hex] [binary] (4) NULL,
[atm_link_uuid] [binary] (16) NULL,
[link_details] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nature] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtatm_interface] ADD CONSTRAINT [XPKwtatm_interface] PRIMARY KEY CLUSTERED ([uuid]) ON [PRIMARY]
GO