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.
name database_id source_database_id owner_sid create_date compatibility_level collation_name user_access user_access_desc is_read_only is_auto_close_on is_auto_shrink_on state state_desc is_in_standby is_cleanly_shutdown is_supplemental_logging_enabled snapshot_isolation_state snapshot_isolation_state_desc is_read_committed_snapshot_on recovery_model recovery_model_desc page_verify_option page_verify_option_desc is_auto_create_stats_on is_auto_create_stats_incremental_on is_auto_update_stats_on is_auto_update_stats_async_on is_ansi_null_default_on is_ansi_nulls_on is_ansi_padding_on is_ansi_warnings_on is_arithabort_on is_concat_null_yields_null_on is_numeric_roundabort_on is_quoted_identifier_on is_recursive_triggers_on is_cursor_close_on_commit_on is_local_cursor_default is_fulltext_enabled is_trustworthy_on is_db_chaining_on is_parameterization_forced is_master_key_encrypted_by_server is_query_store_on is_published is_subscribed is_merge_published is_distributor is_sync_with_backup service_broker_guid is_broker_enabled log_reuse_wait log_reuse_wait_desc is_date_correlation_on is_cdc_enabled is_encrypted is_honor_broker_priority_on replica_id group_database_id resource_pool_id default_language_lcid default_language_name default_fulltext_language_lcid default_fulltext_language_name is_nested_triggers_on is_transform_noise_words_on two_digit_year_cutoff containment containment_desc target_recovery_time_in_seconds delayed_durability delayed_durability_desc is_memory_optimized_elevate_to_snapshot_on
master 1 null 0x01 2003-04-08 09:13:36.390 120 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False True False False False False False False False False 00000000-0000-0000-0000-000000000000 False 0 NOTHING False False False False null null null null null null null null null null 0 NONE 0 0 DISABLED False
tempdb 2 null 0x01 2020-09-09 17:24:11.980 120 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False True False False False False False False False False e9489058-db01-4648-a7be-150346088d65 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE 0 0 DISABLED False
model 3 null 0x01 2003-04-08 09:13:36.390 120 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False False False False False False False False False False False False 00000000-0000-0000-0000-000000000000 False 0 NOTHING False False False False null null null null null null null null null null 0 NONE 0 0 DISABLED False
msdb 4 null 0x01 2014-02-20 20:49:38.857 120 Latin1_General_CI_AS 0 MULTI_USER False False False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True True True False False False False False False False False 7d5b6977-da53-44ed-ae00-3601a3231ea4 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE 0 0 DISABLED False
fiddle_3c5627bd364147edbd2f6698fe7cb8e4 5 null 0x01 2020-04-03 17:04:08.703 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 2af5edeb-76ce-4734-8f24-79028fc36d04 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_a98ad626dc3b492088ac7eaa1b420201 6 null 0x01 2020-04-03 17:04:14.533 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 22a4268d-a6b5-47dd-9881-9999510aa9d9 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_6ed66f5c728740d49dfc23b531a027a5 7 null 0x01 2020-04-03 17:07:15.297 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False b407787b-b70e-459f-b5be-b92ff1124111 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_720ff555048849c49f720ecd36c1c26c 8 null 0x01 2020-04-07 21:59:15.400 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 2ddd17b7-2705-45ed-a3cc-15c6f53c4e16 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_45ab5008ee6c4b61b760d6d111a37fce 9 null 0x01 2020-04-10 00:16:00.810 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False bb22a138-0ebf-407b-8718-288c39488d61 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_c308e2c1e17d49b8b14ebd0adc580b81 10 null 0x01 2020-04-10 00:16:07.543 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False d4689db7-6f4c-42c7-ac3c-b7ec2b503e50 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_f366c07450c14b1b9c54702dc70ebe90 11 null 0x01 2020-05-04 12:31:17.180 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 78a12085-5b67-46d8-b539-73a21e08f1c5 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_e83fdac6b8094a0b8daf1872bd6b2bc4 12 null 0x01 2020-05-04 12:31:21.540 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 264f6a10-3970-46fd-8e3a-c3f8d5c1df9d True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_8da6752971bc46189bb50ecafeb84fb6 13 null 0x01 2020-05-18 09:11:17.150 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 24f97b7c-5f2e-4e1c-b63a-307a806e73eb True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_59c97eadb465481eb4617c719d065784 14 null 0x01 2020-05-18 09:11:23.210 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False fe4904de-da9f-46c9-8b0d-ca5dd703e2f7 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_73316c80c9fa407bbcf69859f45822f0 15 null 0x01 2020-05-18 09:11:37.603 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 39a4517c-b049-4682-b0eb-ded49e6b44cd True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_37fa189c89a248689a92280592f1c449 16 null 0x01 2020-05-18 09:11:47.023 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 7ad043c1-a61b-468d-8925-c912b39cdcf8 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_cf276406df8e497692dd6dfdcf47b385 17 null 0x01 2020-05-18 09:11:59.507 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False d9dc1b19-d191-461b-8ca8-2f15a40ad719 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_cd5c2697521c45cc9bdf3e6bacbfb574 18 null 0x01 2020-05-18 13:19:18.477 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False b0cb65b0-63f9-42f8-825c-a58086362784 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_13a58889e5ca47808776404e667fcd2a 19 null 0x01 2020-05-18 13:19:22.773 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 77495579-3881-4dfb-8ca2-0df0ad46ea3c True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_cd1edb44f9bc4ae88a76a34d3d69d1cc 20 null 0x01 2020-07-20 05:36:10.650 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 34e98526-db8f-48e3-9a5c-a4c2b57d6d59 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_407a749f7e78469d9ab15eb568534100 21 null 0x01 2020-07-21 15:59:02.557 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 5fafa85c-5df7-4d68-9911-b776843abc4e True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_f9c64a1503174cf7a262e2c86765bae7 22 null 0x01 2020-07-21 16:16:43.743 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 57cb3128-d006-42b0-af77-c1919dc8ccff True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_3ca6b348a4b14c4f9af90a0703b0732f 23 null 0x01 2020-07-21 18:21:47.120 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 6a7ae2fb-6166-44fb-9878-e97dd7225cbf True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_aac7774d04f64d43bef2a4a676fc32f3 24 null 0x01 2020-07-21 19:47:07.040 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 3405d4b3-9316-41a8-9d47-88b3de36dd7d True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_d7848c5042564861a2f3edc237c26eda 25 null 0x01 2020-07-21 19:50:25.667 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 74a88cc7-c9ad-41ac-aae3-d4f342d52eb8 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_c97da8cb9ee94b00866e2668bac44159 26 null 0x01 2020-07-21 19:51:09.680 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False eb69e650-199a-4cbf-870a-75ba5775c881 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_80f6667311de4b4f94291b05fb0b707d 27 null 0x01 2020-07-21 19:51:15.370 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 4389ef80-3130-4f0a-bac3-242e77473afc True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_c9df0c693f4640c9972389c88b9b5881 28 null 0x01 2020-07-21 19:51:39.557 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 94f65409-068a-4f67-bf17-6ed3ece2c86d True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_1d7de32b17cc47b6a5ebb0dc7b045c66 29 null 0x01 2020-07-21 19:51:46.883 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 94ebc063-d6ba-429e-9a12-dc7987b43f94 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_245ba2b02a6a4deba66e196280d7c2af 30 null 0x01 2020-07-21 19:55:22.460 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 07ac9ef0-ccc0-49f0-9c0c-66b9965c4576 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_e32dc6087e0a406d89ae61e1df3fa92a 31 null 0x01 2020-07-21 19:55:27.057 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 4d831d44-6b96-4ae3-9b22-446626a5e505 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_78f3b8a5c87a4713abc03469584d6440 32 null 0x01 2020-07-21 19:55:32.133 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 152958d7-2b8e-47c1-af52-5ffaf6af64c0 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_84e542cb05174308a7f094a00d826a5b 33 null 0x01 2020-07-21 19:55:42.510 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 566d190a-a9c7-4051-93db-5b642560f355 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_57d9abe2783a40e3ab90a23ac58717f9 34 null 0x01 2020-07-22 06:04:07.760 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 5619512c-a1ff-48ce-9c3d-12955b3f6e4f True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_9ee5832698534b02801096a891c765d1 35 null 0x01 2020-07-22 07:45:04.930 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 533047e1-cb6a-4eb8-b7c4-87710b5ea3d4 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_c545da184f1a4c0289bcb416074756c1 36 null 0x01 2020-08-05 11:27:28.260 120 null 0 MULTI_USER False True False 0 ONLINE False True False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False b276f3ce-6332-4b26-a99d-2d2f525b15f7 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_3a5056ae71d5498a91d53a0300a09791 37 null 0x01 2020-08-05 16:36:55.270 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 7cec8d9e-eaf2-48d5-adb8-bece1a9e3041 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_4c7f148976f0452f9966588446fa1a0c 38 null 0x01 2020-08-05 20:03:59.290 120 null 0 MULTI_USER False True False 0 ONLINE False True False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 2981aa60-0920-4e5a-a817-463d8f3f45d4 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_cb3417319e264ad4a655de61695d004a 39 null 0x01 2020-09-22 14:34:56.343 120 Latin1_General_CI_AS 0 MULTI_USER False True False 0 ONLINE False False False 1 ON False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 28e58a7b-a32d-4c08-8342-61989ef7e440 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE 0 0 DISABLED False
fiddle_6a444fc12f4147139f7af9a47a6fcdda 42 null 0x01 2020-09-14 06:57:22.380 120 null 0 MULTI_USER False True False 0 ONLINE False True False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False ac74761b-f374-4e7f-b560-2bd779e174ae True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
fiddle_3ecd343f75004d4b84cfed8961788608 43 null 0x01 2020-09-14 02:37:53.023 120 null 0 MULTI_USER False True False 0 ONLINE False True False 0 OFF False 3 SIMPLE 2 CHECKSUM True False True False False False False False False False False False False False False True False False False False False False False False False False 6cdfadf8-b5cc-4225-ae96-60cb284607c9 True 0 NOTHING False False False False null null null null null null null null null null 0 NONE null null null False
collation_name
Latin1_General_CI_AS 
Latin1_General_CI_AS