add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Msg 2714 Level 16 State 5 Line 1
There is already an object named 't' in the database.
Msg 1750 Level 16 State 1 Line 1
Could not create constraint or index. See previous errors.
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 917578307 null 1 0 U USER_TABLE 2022-12-03 16:24:49.203 2022-12-03 16:24:49.203 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
917578307 t1 2 2 NONCLUSTERED False 1 False False False 0 False False False False True True False null null False False