[aiowner].[ai_fsdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	508
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())
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__06D35FAF] 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