SELECT TABLE_NAME 'Table', COLUMN_NAME 'Field', COLUMN_TYPE 'Type', IS_NULLABLE 'Null',   
COLUMN_KEY 'Key', COLUMN_DEFAULT 'Default', EXTRA 'Extra' FROM information_schema.columns WHERE 
table_schema = 'yourdb' ORDER BY TABLE_NAME;
