By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_PRECISION_RADIX | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_CATALOG | CHARACTER_SET_SCHEMA | CHARACTER_SET_NAME | COLLATION_CATALOG | COLLATION_SCHEMA | COLLATION_NAME | DOMAIN_CATALOG | DOMAIN_SCHEMA | DOMAIN_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t | City | 1 | null | NO | varchar | 3 | 3 | null | null | null | null | null | null | iso_1 | null | null | SQL_Latin1_General_CP1_CI_AS | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t | Country | 2 | null | NO | varchar | 3 | 3 | null | null | null | null | null | null | iso_1 | null | null | SQL_Latin1_General_CP1_CI_AS | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t | Density | 3 | null | NO | numeric | null | null | 3 | 10 | 2 | null | null | null | null | null | null | null | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t | CityAvg | 4 | null | YES | int | null | null | 10 | 10 | 0 | null | null | null | null | null | null | null | null | null | null |
1 rows affected
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_PRECISION_RADIX | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_CATALOG | CHARACTER_SET_SCHEMA | CHARACTER_SET_NAME | COLLATION_CATALOG | COLLATION_SCHEMA | COLLATION_NAME | DOMAIN_CATALOG | DOMAIN_SCHEMA | DOMAIN_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t2 | City | 1 | null | NO | varchar | 3 | 3 | null | null | null | null | null | null | iso_1 | null | null | SQL_Latin1_General_CP1_CI_AS | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t2 | Country | 2 | null | NO | varchar | 3 | 3 | null | null | null | null | null | null | iso_1 | null | null | SQL_Latin1_General_CP1_CI_AS | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t2 | Density | 3 | null | NO | numeric | null | null | 3 | 10 | 2 | null | null | null | null | null | null | null | null | null | null |
| fiddle_085d9057e40c46cbae8d3482fb337bf0 | dbo | t2 | CityAvg | 4 | null | YES | numeric | null | null | 3 | 10 | 2 | null | null | null | null | null | null | null | null | null | null |