By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| name | collation_name |
|---|---|
| key | Latin1_General_BIN2 |
| value | SQL_Latin1_General_CP1_CI_AS |
| type | null |
| is_hidden | column_ordinal | name | is_nullable | system_type_id | system_type_name | max_length | precision | scale | collation_name | user_type_id | user_type_database | user_type_schema | user_type_name | assembly_qualified_type_name | xml_collection_id | xml_collection_database | xml_collection_schema | xml_collection_name | is_xml_document | is_case_sensitive | is_fixed_length_clr_type | source_server | source_database | source_schema | source_table | source_column | is_identity_column | is_part_of_unique_key | is_updateable | is_computed_column | is_sparse_column_set | ordinal_in_order_by_list | order_by_is_descending | order_by_list_length | tds_type_id | tds_length | tds_collation_id | tds_collation_sort_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| False | 1 | key | False | 231 | nvarchar(4000) | 8000 | 0 | 0 | Latin1_General_BIN2 | null | null | null | null | null | null | null | null | null | False | True | False | null | null | null | null | null | False | null | False | False | False | null | null | null | 231 | 8000 | 33555465 | 0 |
| False | 2 | value | True | 231 | nvarchar(max) | -1 | 0 | 0 | SQL_Latin1_General_CP1_CI_AS | null | null | null | null | null | null | null | null | null | False | False | False | null | null | null | null | null | False | null | False | False | False | null | null | null | 231 | 65535 | 13632521 | 52 |
| False | 3 | type | False | 48 | tinyint | 1 | 3 | 0 | null | null | null | null | null | null | null | null | null | null | False | False | False | null | null | null | null | null | False | null | False | False | False | null | null | null | 48 | 1 | null | null |
| name | system_type_id | collation_name | is_nullable |
|---|---|---|---|
| key | 231 | Latin1_General_BIN2 | False |
| value | 231 | SQL_Latin1_General_CP1_CI_AS | True |
| type | 48 | null | False |