[dbo].[PUBLISH]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	98
Created	3:44:40 PM Friday, June 13, 2003
Last Modified	3:44:40 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

3:44:40 PM Friday, June 13, 2003

Last Modified

3:44:40 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$	DOMAINID	int	4
$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$	PUBID	int	4
	PUBNAME	varchar(64)	64
	PUBADD	varchar(127)	127
	PUBCOUNT	varchar(30)	30
	PUBPHONE	varchar(30)	30
	PUBMAIL	varchar(80)	80
	PUBFAX	varchar(30)	30
	PUBWWW	varchar(50)	50
	PUBBBS	varchar(30)	30
	PUBTEXT	text	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$

DOMAINID

int

$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$

PUBID

int

PUBNAME

varchar(64)

PUBADD

varchar(127)

127

PUBCOUNT

varchar(30)

PUBPHONE

varchar(30)

PUBMAIL

varchar(80)

PUBFAX

varchar(30)

PUBWWW

varchar(50)

PUBBBS

varchar(30)

PUBTEXT

text

max

	Name	Columns	Unique
$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$	PUBLISH_PK	PUBID, DOMAINID

Name

Columns

Unique

$Cluster Primary Key PUBLISH_PK: PUBID\DOMAINID$

PUBLISH_PK

PUBID, DOMAINID

SQL Script

CREATE TABLE [dbo].[PUBLISH]
(
[DOMAINID] [int] NOT NULL,
[PUBID] [int] NOT NULL,
[PUBNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBADD] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBCOUNT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBPHONE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBMAIL] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBFAX] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBWWW] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBBBS] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PUBTEXT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[PUBLISH] ADD CONSTRAINT [PUBLISH_PK] PRIMARY KEY CLUSTERED ([PUBID], [DOMAINID]) ON [PRIMARY]
GO