[aiowner].[ai_swdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	44566
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
pubuuid	uniqueidentifier	16
swuuid	uniqueidentifier	16	(newid())
swpub	nvarchar(128)	256	('')
swname	nvarchar(128)	256	('')
swver	nvarchar(128)	256
swrel	nvarchar(128)	256
swmod	nvarchar(128)	256
swbld	nvarchar(128)	256
swnote	nvarchar(128)	256
swlang	nvarchar(128)	256
laction	nvarchar(32)	64	('ADDED')
lactdate	datetime	8	(getdate())

SQL Script

CREATE TABLE [aiowner].[ai_swdef_prop_p]
(
[pubuuid] [uniqueidentifier] NULL,
[swuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_swdef___swuui__2557E6CF] DEFAULT (newid()),
[swpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_swdef___swpub__264C0B08] DEFAULT (''),
[swname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swnam__27402F41] DEFAULT (''),
[swver] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swrel] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swmod] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swbld] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swnote] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[swlang] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_swdef___lacti__2834537A] DEFAULT ('ADDED'),
[lactdate] [datetime] NOT NULL CONSTRAINT [DF__ai_swdef___lactd__292877B3] DEFAULT (getdate())
) ON [PRIMARY]
GO