[aiowner].[ai_pubdef_prop

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	3471
Created	9:12:28 AM Thursday, November 06, 2008
Last Modified	9:12:28 AM Thursday, November 06, 2008

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

3471

Created

9:12:28 AM Thursday, November 06, 2008

Last Modified

9:12:28 AM Thursday, November 06, 2008

Name	Data Type	Max Length (Bytes)	Default
source_domuuid_char	varchar(36)	36
source_pubuuid_char	varchar(36)	36
source_domuuid	uniqueidentifier	16
source_pubuuid	uniqueidentifier	16
source_domid	int	4
source_pubid	int	4	('')
pubuuid	uniqueidentifier	16
pubname	nvarchar(255)	510

Name

Data Type

Max Length (Bytes)

Allow Nulls

Default

source_domuuid_char

varchar(36)

source_pubuuid_char

varchar(36)

source_domuuid

uniqueidentifier

source_pubuuid

uniqueidentifier

source_domid

int

source_pubid

int

('')

pubuuid

uniqueidentifier

pubname

nvarchar(255)

510

SQL Script

CREATE TABLE [aiowner].[ai_pubdef_prop_s]
(
[source_domuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_pubuuid_char] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[source_domuuid] [uniqueidentifier] NULL,
[source_pubuuid] [uniqueidentifier] NULL,
[source_domid] [int] NULL,
[source_pubid] [int] NULL CONSTRAINT [DF__ai_pubdef__sourc__47ACFED3] DEFAULT (''),
[pubuuid] [uniqueidentifier] NULL,
[pubname] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO