PARTITION_DIRECTORY

Definition

The table contains the directories where tablespaces or filegroups are saved

Technical Data

Schema Version	4.5.2
Filegroup	BART_DATA
Partitioned	No

Summary

The PARTITION_DIRECTORY table is defined by the following columns. See the column details for more information.

Name	PK	FK	IX	Uses	Used by
DIRECTORY_ID	PK_PARTITION_DIRECTORY
DIRECTORY
FILE_SIZE
EXTEND_SIZE
ACTIVE

Column Details

DIRECTORY_ID

Definition	The identifier of the directory
Type	DECIMAL(3), NOT NULL
Primary Key	PK_PARTITION_DIRECTORY

DIRECTORY

Definition	The directory
Type	NVARCHAR(2000), NULL

FILE_SIZE

Definition	The size of the tablespace or filegroup
Type	NVARCHAR(28), NULL

EXTEND_SIZE

Definition	The extent size of the tablespace or filegroup
Type	NVARCHAR(28), NULL

ACTIVE

Definition
Type	DECIMAL(1), NULL

Primary Key Details

PK_PARTITION_DIRECTORY

Column(s)	DIRECTORY_ID
Filegroup	BART_DATA