Tables [aiowner].[ai_swdef_prop_p]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count48526
Created11:24:56 PM Monday, January 10, 2011
Last Modified11:24:56 PM Monday, January 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
pubuuiduniqueidentifier16
Yes
swuuiduniqueidentifier16
No
(newid())
swpubnvarchar(128)256
Yes
('')
swnamenvarchar(128)256
No
('')
swvernvarchar(128)256
Yes
swrelnvarchar(128)256
Yes
swmodnvarchar(128)256
Yes
swbldnvarchar(128)256
Yes
swnotenvarchar(128)256
Yes
swlangnvarchar(128)256
Yes
lactionnvarchar(32)64
Yes
('ADDED')
lactdatedatetime8
No
(getdate())
SQL Script
CREATE TABLE [aiowner].[ai_swdef_prop_p]
(
[pubuuid] [uniqueidentifier] NULL,
[swuuid] [uniqueidentifier] NOT NULL CONSTRAINT [DF__ai_swdef___swuui__3E65EDC0] DEFAULT (newid()),
[swpub] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__ai_swdef___swpub__3F5A11F9] DEFAULT (''),
[swname] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__ai_swdef___swnam__404E3632] 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__41425A6B] DEFAULT ('ADDED'),
[lactdate] [datetime] NOT NULL CONSTRAINT [DF__ai_swdef___lactd__42367EA4] DEFAULT (getdate())
) ON [PRIMARY]

GO
Uses