How to get all columns names for all the tables in MySQL

Question

How to get  all column names from all tables in MySQL, without having to list all the tables? Want to know the query for applying it?

Answer 1

Hello @kartik,

Try this:

select * from information_schema.columns
where table_schema = 'your_db'
order by table_name,ordinal_position

Hope it helps!!

Thank You!!