Tables [aiowner].[ai_pubdef_prop_p]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count3466
Created9:12:21 AM Thursday, November 06, 2008
Last Modified9:12:21 AM Thursday, November 06, 2008
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
pubuuiduniqueidentifier16
No
(newid())
pubnamenvarchar(128)256
No
lactionnvarchar(32)64
Yes
('ADDED')
lactdatedatetime8
Yes
(getdate())
SQL Script
CREATE TABLE [aiowner].[ai_pubdef_prop_p]
(
[pubuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_pubdef__pubuu__13393694] DEFAULT (newid()),
[pubname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[laction] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_pubdef__lacti__142D5ACD] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_pubdef__lactd__15217F06] DEFAULT (getdate())
) ON [PRIMARY]
GO
Uses