Apr 16, 2013
Table fields
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = [THE_TABLE_NAME_HERE] ORDER BY TABLE_CATALOG, TABLE_NAME, ORDINAL_POSITION
seen from United States
seen from T1
seen from Tunisia
seen from Singapore
seen from Belgium
seen from Malaysia
seen from Lithuania
seen from United States
seen from Malaysia
seen from Ireland
seen from United States
seen from India
seen from China
seen from United States
seen from United States
seen from Türkiye
seen from United States
seen from Australia
seen from United States
seen from Ireland
Table fields
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = [THE_TABLE_NAME_HERE] ORDER BY TABLE_CATALOG, TABLE_NAME, ORDINAL_POSITION