[dbo].[RPRESULT]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	35
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 RPRESULT_PK: TPLID\TPLSUBID\RESID$	TPLID	int	4
$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$	TPLSUBID	int	4
$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$	RESID	int	4
	TBLNAME	varchar(64)	64
	DISPNAME	varchar(64)	64
	FILTER	int	4
	STATUS	int	4
	RESSPEC	text	max
	CREATED	int	4
	CREATEBY	varchar(64)	64

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$

TPLID

int

$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$

TPLSUBID

int

$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$

RESID

int

TBLNAME

varchar(64)

DISPNAME

varchar(64)

FILTER

int

STATUS

int

RESSPEC

text

max

CREATED

int

CREATEBY

varchar(64)

	Name	Columns	Unique
$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$	RPRESULT_PK	TPLID, TPLSUBID, RESID

Name

Columns

Unique

$Primary Key RPRESULT_PK: TPLID\TPLSUBID\RESID$

RPRESULT_PK

TPLID, TPLSUBID, RESID

SQL Script

CREATE TABLE [dbo].[RPRESULT]
(
[TPLID] [int] NOT NULL,
[TPLSUBID] [int] NOT NULL,
[RESID] [int] NOT NULL,
[TBLNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DISPNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FILTER] [int] NULL,
[STATUS] [int] NULL,
[RESSPEC] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CREATED] [int] NULL,
[CREATEBY] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPRESULT] ADD CONSTRAINT [RPRESULT_PK] PRIMARY KEY NONCLUSTERED ([TPLID], [TPLSUBID], [RESID]) ON [PRIMARY]
GO