[dbo].[BCKDEF]

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

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

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

Last Modified

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

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$	DOMAINID	int	4
$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$	BCKID	int	4
	DBNAME	varchar(50)	50
	FILENAME	varchar(127)	127
	VERSION	int	4
	BCKFLAG	int	4
	EDITOR	varchar(50)	50
	REVNR	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$

DOMAINID

int

$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$

BCKID

int

DBNAME

varchar(50)

FILENAME

varchar(127)

127

VERSION

int

BCKFLAG

int

EDITOR

varchar(50)

REVNR

int

	Name	Columns	Unique
$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$	BCKDEF_PK	BCKID, DOMAINID
	BCKDEF_SK1	DBNAME

Name

Columns

Unique

$Cluster Primary Key BCKDEF_PK: BCKID\DOMAINID$

BCKDEF_PK

BCKID, DOMAINID

BCKDEF_SK1

DBNAME

SQL Script

CREATE TABLE [dbo].[BCKDEF]
(
[DOMAINID] [int] NOT NULL,
[BCKID] [int] NOT NULL,
[DBNAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FILENAME] [varchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[VERSION] [int] NULL,
[BCKFLAG] [int] NULL,
[EDITOR] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[REVNR] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BCKDEF] ADD CONSTRAINT [BCKDEF_PK] PRIMARY KEY CLUSTERED ([BCKID], [DOMAINID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [BCKDEF_SK1] ON [dbo].[BCKDEF] ([DBNAME]) ON [PRIMARY]
GO