By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| name | object_id | principal_id | schema_id | parent_object_id | type | type_desc | create_date | modify_date | is_ms_shipped | is_published | is_schema_published | lob_data_space_id | filestream_data_space_id | max_column_id_used | lock_on_bulk_load | uses_ansi_nulls | is_replicated | has_replication_filter | is_merge_published | is_sync_tran_subscribed | has_unchecked_assembly_data | text_in_row_limit | large_value_types_out_of_row | is_tracked_by_cdc | lock_escalation | lock_escalation_desc | is_filetable | is_memory_optimized | durability | durability_desc | temporal_type | temporal_type_desc | history_table_id | is_remote_data_archive_enabled | is_external | history_retention_period | history_retention_period_unit | history_retention_period_unit_desc | is_node | is_edge |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| t | 885578193 | null | 1 | 0 | U | USER_TABLE | 09/01/2019 21:42:37 | 09/01/2019 21:42:37 | False | False | False | 0 | null | 2 | False | True | False | False | False | False | False | 0 | False | False | 0 | TABLE | False | False | 0 | SCHEMA_AND_DATA | 0 | NON_TEMPORAL_TABLE | null | False | False | null | null | null | False | False |
| object_id | name | index_id | type | type_desc | is_unique | data_space_id | ignore_dup_key | is_primary_key | is_unique_constraint | fill_factor | is_padded | is_disabled | is_hypothetical | is_ignored_in_optimization | allow_row_locks | allow_page_locks | has_filter | filter_definition | compression_delay | suppress_dup_key_messages | auto_created |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 885578193 | t | 2 | 2 | NONCLUSTERED | False | 1 | False | False | False | 0 | False | False | False | False | True | True | False | null | null | False | False |