[aiowner].[ai_pubdef_prop

[aiowner].[ai_pubdef_prop_p]

(local) > mdb > Tables > aiowner.ai_pubdef_prop_p

Properties
Columns
SQL Script
Uses

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

Columns

Name	Data Type	Max Length (Bytes)	Default
pubuuid	uniqueidentifier	16	(newid())
pubname	nvarchar(128)	256
laction	nvarchar(32)	64	('ADDED')
lactdate	datetime	8	(getdate())

SQL Script

CREATE TABLE [aiowner].[ai_pubdef_prop_p]
(
[pubuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_pubdef__pubuu__2C473D85] 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__2D3B61BE] DEFAULT ('ADDED'),
[lactdate] [datetime] NULL CONSTRAINT [DF__ai_pubdef__lactd__2E2F85F7] DEFAULT (getdate())
) ON [PRIMARY]

GO

Uses

aiowner