Tables [aiowner].[ai_fddef_prop_p]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count198
Created9:12:21 AM Thursday, November 06, 2008
Last Modified9:12:21 AM Thursday, November 06, 2008
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
hwuuiduniqueidentifier16
No
(newid())
fddevicenvarchar(128)256
Yes
fdvendornvarchar(128)256
Yes
fdmodelnvarchar(128)256
Yes
fdinterfacenvarchar(128)256
Yes
fdsizereal4
Yes
fdsnnvarchar(128)256
Yes
fdstatusnvarchar(128)256
Yes
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
Uses