[aiowner].[ai_swcat_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	2562
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
scuuid	uniqueidentifier	16	(newid())
scname	nvarchar(128)	256
scnote	nvarchar(255)	510
laction	nvarchar(32)	64	('ADDED')
lactdate	datetime	8	(getdate())
createdate	datetime	8	(getdate())
createuser	nvarchar(32)	64	('UAM')

SQL Script

CREATE TABLE [aiowner].[ai_swcat_prop_p]
(
[scuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_swcat___scuui__1F9F0D79] DEFAULT (newid()),
[scname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[scnote] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_swcat___lacti__209331B2] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_swcat___lactd__218755EB] DEFAULT (getdate()),
[createdate] [datetime] NULL CONSTRAINT [DF__ai_swcat___creat__227B7A24] DEFAULT (getdate()),
[createuser] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_swcat___creat__236F9E5D] DEFAULT ('UAM')
) ON [PRIMARY]
GO