How to get information about the table?
To retrieve entire information of a table, we use DESCRIBE, DESC or SHOW COLUMNS statements.
Syntax:
Filtering columns to be shown:
We can specify the name of the database along with the table name as shown in the query below
Usually, the information provided by the SHOW COLUMNS statements contains field type, can be null or not, key, default values and some extra details. If you use the full clause details like collation, privileges and comments will be added.