[aiowner].[ai_fddef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	198
Created	9:12:21 AM Thursday, November 06, 2008
Last Modified	9:12:21 AM Thursday, November 06, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

198

Created

9:12:21 AM Thursday, November 06, 2008

Last Modified

9:12:21 AM Thursday, November 06, 2008

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__04EB173D] 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