[aiowner].[ai_osdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	157
Created	9:12:28 AM Thursday, November 06, 2008
Last Modified	9:12:28 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
osuuid	uniqueidentifier	16
osname	nvarchar(128)	256
ospub	nvarchar(128)	256
osver	nvarchar(128)	256
osbuild	nvarchar(128)	256
ossp	nvarchar(128)	256
oslanguage	nvarchar(128)	256

SQL Script

CREATE TABLE [aiowner].[ai_osdef_prop_s]
(
[source_set_priority] [int] 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,
[osuuid] [uniqueidentifier] NULL,
[osname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ospub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osbuild] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ossp] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[oslanguage] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO