[dbo].[RPTREE]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count	134
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

134

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 RPTREE_PK: ROOT\OWNERID\OBJID$	ROOT	int	4
$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$	OWNERID	int	4
$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$	OBJID	int	4
	OBJNAME	varchar(64)	64
	DESCRIPT	text	max
	STATUS	int	4
	CREATED	int	4
	CREATEBY	varchar(64)	64
	MODIFIED	int	4
	MODIFIBY	varchar(64)	64
	TYPE	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$

ROOT

int

$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$

OWNERID

int

$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$

OBJID

int

OBJNAME

varchar(64)

DESCRIPT

text

max

STATUS

int

CREATED

int

CREATEBY

varchar(64)

MODIFIED

int

MODIFIBY

varchar(64)

TYPE

int

	Name	Columns	Unique
$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$	RPTREE_PK	ROOT, OWNERID, OBJID

Name

Columns

Unique

$Primary Key RPTREE_PK: ROOT\OWNERID\OBJID$

RPTREE_PK

ROOT, OWNERID, OBJID

SQL Script

CREATE TABLE [dbo].[RPTREE]
(
[ROOT] [int] NOT NULL,
[OWNERID] [int] NOT NULL,
[OBJID] [int] NOT NULL,
[OBJNAME] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DESCRIPT] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[STATUS] [int] NULL,
[CREATED] [int] NULL,
[CREATEBY] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MODIFIED] [int] NULL,
[MODIFIBY] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPTREE] ADD CONSTRAINT [RPTREE_PK] PRIMARY KEY NONCLUSTERED ([ROOT], [OWNERID], [OBJID]) ON [PRIMARY]
GO