[dbo].[RPVIEW]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	69
Created	3:44:41 PM Friday, June 13, 2003
Last Modified	3:44:41 PM Friday, June 13, 2003

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Heap

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Primary Key RPVIEW_PK: TPLID\VIEWID$	TPLID	int	4
$Primary Key RPVIEW_PK: TPLID\VIEWID$	VIEWID	int	4
	FIELD1	varchar(127)	127
	FIELD2	varchar(127)	127
	FIELD3	varchar(127)	127
	FIELD4	varchar(127)	127
	SETTINGS	text	max

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key RPVIEW_PK: TPLID\VIEWID$

TPLID

int

$Primary Key RPVIEW_PK: TPLID\VIEWID$

VIEWID

int

FIELD1

varchar(127)

127

FIELD2

varchar(127)

127

FIELD3

varchar(127)

127

FIELD4

varchar(127)

127

SETTINGS

text

max

	Name	Columns	Unique
$Primary Key RPVIEW_PK: TPLID\VIEWID$	RPVIEW_PK	TPLID, VIEWID

Name

Columns

Unique

$Primary Key RPVIEW_PK: TPLID\VIEWID$

RPVIEW_PK

TPLID, VIEWID

SQL Script

CREATE TABLE [dbo].[RPVIEW]
(
[TPLID] [int] NOT NULL,
[VIEWID] [int] NOT NULL,
[FIELD1] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIELD2] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIELD3] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FIELD4] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SETTINGS] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPVIEW] ADD CONSTRAINT [RPVIEW_PK] PRIMARY KEY NONCLUSTERED ([TPLID], [VIEWID]) ON [PRIMARY]
GO