SELECT
column_name 'Column Name',
data_type 'Data Type',
character_maximum_length 'Maximum Length'
FROM
information_schema.columns
WHERE
table_name = 'Your Table Name'

Comments (0)