[aiowner].[ai_fsdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	408
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())
fsdevice	nvarchar(128)	256
fsname	nvarchar(128)	256
fslabel	nvarchar(128)	256
fstype	nvarchar(128)	256
fssize	real	4
fsused	real	4
fsfree	real	4

SQL Script

CREATE TABLE [aiowner].[ai_fsdef_prop_p]
(
[hwuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_fsdef___hwuui__1DF91E2E] DEFAULT (newid()),
[fsdevice] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fsname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fslabel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fstype] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fssize] [real] NULL,
[fsused] [real] NULL,
[fsfree] [real] NULL
) ON [PRIMARY]

GO