In MySQL we can use the SHOW COLUMNS
statement to get information about the columns in a table or view.
We can narrow the columns down to just a certain table and database. We can also filter by column name using a pattern.
The SHOW COLUMNS
statement only shows information about columns that we have some privilege.