[aiowner].[ai_osdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	46
Created	11:24:56 PM Monday, January 10, 2011
Last Modified	11:24:56 PM Monday, January 10, 2011

Name	Data Type	Max Length (Bytes)	Default
osuuid	uniqueidentifier	16	(newid())
ospub	nvarchar(128)	256
osname	nvarchar(128)	256
osver	nvarchar(128)	256
osbuild	nvarchar(128)	256
ossp	nvarchar(128)	256
oslanguage	nvarchar(128)	256
laction	nvarchar(32)	64	('ADDED')
lactdate	datetime	8	(getdate())

SQL Script

CREATE TABLE [aiowner].[ai_osdef_prop_p]
(
[osuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_osdef___osuui__34DC8386] DEFAULT (newid()),
[ospub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT 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,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_osdef___lacti__35D0A7BF] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_osdef___lactd__36C4CBF8] DEFAULT (getdate())
) ON [PRIMARY]

GO