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 in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| DIRECTORY_ID | PK_PARTITION_DIRECTORY |
|
The identifier of the directory | |||
| DIRECTORY |
|
The directory | ||||
| FILE_SIZE |
|
The size of the tablespace or filegroup | ||||
| EXTEND_SIZE |
|
The extent size of the tablespace or filegroup | ||||
| ACTIVE |
|
Column Details
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
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
See the primary key information:
PK_PARTITION_DIRECTORY
| Column(s) | DIRECTORY_ID |
| Filegroup | BART_DATA |