Home » mysql » Finding all column name of table

Finding all column name of table

Suppose we have a table user and we want to fetch all its column name.
For this we use INFORMATION_SCHEMA.

we will use following query to fetch all column name of table

Above query will fetch all columns of user table available in social database.

Managed by MochaHost - Fast & Easy WordPress Hosting