How to Get Table Full Detail From System Table

SELECT column_name 'Column Name',data_type 'Data Type',CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE table_name = 'TABLENAME'