[aiowner].[ai_fddef_prop

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

Name	Data Type	Max Length (Bytes)
source_set_priority	int	4
source_domuuid_char	varchar(36)	36
source_hwuuid_char	varchar(36)	36
source_domain_id	int	4
source_unit_id	int	4
domuuid	uniqueidentifier	16
hwuuid	uniqueidentifier	16
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

SQL Script

CREATE TABLE [aiowner].[ai_fddef_prop_s]
(
[source_set_priority] [int] NOT NULL,
[source_domuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_hwuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_domain_id] [int] NULL,
[source_unit_id] [int] NULL,
[domuuid] [uniqueidentifier] NULL,
[hwuuid] [uniqueidentifier] NULL,
[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