Example:
One Table
SELECT column_name,data_type,Character_maximum_length as size
FROM INFORMATION_SCHEMA.COLUMNS
where table_name = 'orders'
All Tables
SELECT Table_name,column_name,data_type,Character_maximum_length as size
FROM INFORMATION_SCHEMA.COLUMNS
|
|
