Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| database_id | int | 4 | null |
|
|
|||
| file_id | int | 4 | null |
|
|
|||
| file_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| type | tinyint | 1 | null |
|
|
|||
| type_desc | nvarchar | 120 | √ | null |
|
|
||
| data_space_id | int | 4 | null |
|
|
|||
| name | sysname | 256 | null |
|
|
|||
| physical_name | nvarchar | 520 | null |
|
|
|||
| state | tinyint | 1 | √ | null |
|
|
||
| state_desc | nvarchar | 120 | √ | null |
|
|
||
| size | int | 4 | null |
|
|
|||
| max_size | int | 4 | null |
|
|
|||
| growth | int | 4 | null |
|
|
|||
| is_media_read_only | bit | 1 | null |
|
|
|||
| is_read_only | bit | 1 | null |
|
|
|||
| is_sparse | bit | 1 | null |
|
|
|||
| is_percent_growth | bit | 1 | null |
|
|
|||
| is_name_reserved | bit | 1 | null |
|
|
|||
| is_persistent_log_buffer | bit | 1 | null |
|
|
|||
| create_lsn | numeric | 27 | √ | null |
|
|
||
| drop_lsn | numeric | 27 | √ | null |
|
|
||
| read_only_lsn | numeric | 27 | √ | null |
|
|
||
| read_write_lsn | numeric | 27 | √ | null |
|
|
||
| differential_base_lsn | numeric | 27 | √ | null |
|
|
||
| differential_base_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| differential_base_time | datetime | 16,3 | √ | null |
|
|
||
| redo_start_lsn | numeric | 27 | √ | null |
|
|
||
| redo_start_fork_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| redo_target_lsn | numeric | 27 | √ | null |
|
|
||
| redo_target_fork_guid | uniqueidentifier | 16 | √ | null |
|
|
||
| backup_lsn | numeric | 27 | √ | null |
|
|
||
| credential_id | int | 4 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
