PARTITION_DIRECTORY
Definition
The table contains the directories where tablespaces or filegroups are saved
Technical Data
| Schema Version | 4.5.2 | |
| 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 |
|---|---|---|---|---|---|
| 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 |
| Tablespace | BART_INDX |