[aiowner].[ai_fddef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	175
Created	11:24:55 PM Monday, January 10, 2011
Last Modified	11:24:55 PM Monday, January 10, 2011

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

175

Created

11:24:55 PM Monday, January 10, 2011

Last Modified

11:24:55 PM Monday, January 10, 2011

Name	Data Type	Max Length (Bytes)	Default
hwuuid	uniqueidentifier	16	(newid())
fddevice	nvarchar(128)	256
fdvendor	nvarchar(128)	256
fdmodel	nvarchar(128)	256
fdinterface	nvarchar(128)	256
fdsize	real	4
fdsn	nvarchar(128)	256
fdstatus	nvarchar(128)	256

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

hwuuid

uniqueidentifier

(newid())

fddevice

nvarchar(128)

256

fdvendor

nvarchar(128)

256

fdmodel

nvarchar(128)

256

fdinterface

nvarchar(128)

256

fdsize

real

fdsn

nvarchar(128)

256

fdstatus

nvarchar(128)

256

SQL Script

CREATE TABLE [aiowner].[ai_fddef_prop_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_fddef___hwuui__1C10D5BC] DEFAULT (newid()),
[fddevice] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fdvendor] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fdmodel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fdinterface] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fdsize] [real] NULL,
[fdsn] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fdstatus] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

GO