databases


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name sysname 256 null
database_id int 4 null
source_database_id int 4 √ null
owner_sid varbinary 85 √ null
create_date datetime 16,3 null
compatibility_level tinyint 1 null
collation_name sysname 256 √ null
user_access tinyint 1 √ null
user_access_desc nvarchar 120 √ null
is_read_only bit 1 √ null
is_auto_close_on bit 1 null
is_auto_shrink_on bit 1 √ null
state tinyint 1 √ null
state_desc nvarchar 120 √ null
is_in_standby bit 1 √ null
is_cleanly_shutdown bit 1 √ null
is_supplemental_logging_enabled bit 1 √ null
snapshot_isolation_state tinyint 1 √ null
snapshot_isolation_state_desc nvarchar 120 √ null
is_read_committed_snapshot_on bit 1 √ null
recovery_model tinyint 1 √ null
recovery_model_desc nvarchar 120 √ null
page_verify_option tinyint 1 √ null
page_verify_option_desc nvarchar 120 √ null
is_auto_create_stats_on bit 1 √ null
is_auto_create_stats_incremental_on bit 1 √ null
is_auto_update_stats_on bit 1 √ null
is_auto_update_stats_async_on bit 1 √ null
is_ansi_null_default_on bit 1 √ null
is_ansi_nulls_on bit 1 √ null
is_ansi_padding_on bit 1 √ null
is_ansi_warnings_on bit 1 √ null
is_arithabort_on bit 1 √ null
is_concat_null_yields_null_on bit 1 √ null
is_numeric_roundabort_on bit 1 √ null
is_quoted_identifier_on bit 1 √ null
is_recursive_triggers_on bit 1 √ null
is_cursor_close_on_commit_on bit 1 √ null
is_local_cursor_default bit 1 √ null
is_fulltext_enabled bit 1 √ null
is_trustworthy_on bit 1 √ null
is_db_chaining_on bit 1 √ null
is_parameterization_forced bit 1 √ null
is_master_key_encrypted_by_server bit 1 null
is_query_store_on bit 1 √ null
is_published bit 1 null
is_subscribed bit 1 null
is_merge_published bit 1 null
is_distributor bit 1 null
is_sync_with_backup bit 1 null
service_broker_guid uniqueidentifier 16 null
is_broker_enabled bit 1 null
log_reuse_wait tinyint 1 √ null
log_reuse_wait_desc nvarchar 120 √ null
is_date_correlation_on bit 1 null
is_cdc_enabled bit 1 null
is_encrypted bit 1 √ null
is_honor_broker_priority_on bit 1 √ null
replica_id uniqueidentifier 16 √ null
group_database_id uniqueidentifier 16 √ null
resource_pool_id int 4 √ null
default_language_lcid smallint 2 √ null
default_language_name nvarchar 256 √ null
default_fulltext_language_lcid int 4 √ null
default_fulltext_language_name nvarchar 256 √ null
is_nested_triggers_on bit 1 √ null
is_transform_noise_words_on bit 1 √ null
two_digit_year_cutoff smallint 2 √ null
containment tinyint 1 √ null
containment_desc nvarchar 120 √ null
target_recovery_time_in_seconds int 4 √ null
delayed_durability int 4 √ null
delayed_durability_desc nvarchar 120 √ null
is_memory_optimized_elevate_to_snapshot_on bit 1 √ null
is_federation_member bit 1 √ null
is_remote_data_archive_enabled bit 1 √ null
is_mixed_page_allocation_on bit 1 √ null
is_temporal_history_retention_enabled bit 1 √ null
catalog_collation_type int 4 null
catalog_collation_type_desc nvarchar 120 √ null
physical_database_name nvarchar 256 √ null
is_result_set_caching_on bit 1 √ null
is_accelerated_database_recovery_on bit 1 √ null
is_tempdb_spill_to_remote_store bit 1 √ null
is_stale_page_detection_on bit 1 √ null
is_memory_optimized_enabled bit 1 √ null

Relationships

Close relationships within degrees of separation