SELECT TABLE_SCHEMA AS 'Schema', TABLE_NAME AS 'Table', COLUMN_NAME AS 'Column', DATA_TYPE AS 'Type' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "YOUR_DATABASE_NAME"