SELECT
tables.table_schema,
tables.table_name,
columns.column_name,
columns.ordinal_position,
columns.is_nullable,
columns.data_type
FROM information_schema.tables AS tables
INNER JOIN information_schema.columns AS columns
ON tables.table_name = columns.table_name
WHERE
tables.table_schema = 'replays'
ORDER BY
tables.table_name ASC,
columns.ordinal_position ASC;