[aiowner].[ai_osdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	56
Created	9:12:22 AM Thursday, November 06, 2008
Last Modified	9:12:22 AM Thursday, November 06, 2008

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__1BCE7C95] 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__1CC2A0CE] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_osdef___lactd__1DB6C507] DEFAULT (getdate())
) ON [PRIMARY]
GO