Tables [aiowner].[ai_fsdef_prop_s]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count508
Created9:12:25 AM Thursday, November 06, 2008
Last Modified9:12:25 AM Thursday, November 06, 2008
Columns
NameData TypeMax Length (Bytes)Allow Nulls
source_set_priorityint4
No
source_domuuid_charvarchar(36)36
Yes
source_hwuuid_charvarchar(36)36
Yes
source_domain_idint4
Yes
source_unit_idint4
Yes
domuuiduniqueidentifier16
Yes
hwuuiduniqueidentifier16
Yes
fsdevicenvarchar(128)256
Yes
fsnamenvarchar(128)256
Yes
fslabelnvarchar(128)256
Yes
fstypenvarchar(128)256
Yes
fssizereal4
Yes
fsusedreal4
Yes
fsfreereal4
Yes
SQL Script
CREATE TABLE [aiowner].[ai_fsdef_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,
[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
Uses