SQL Show columns Query is for showing the structure of tables. For example what are the different columns in avaiable in a table, what are their datatypes etc.
SYNTAX:
Show Columns From Nameoftable
EXAMPLE:
Show Columns From items
DESCRIPTION:
“SHOW COLUMNS” is used to see all the columns from a table. For instance, if you have a table named items, you can view all the columns of this table by using show columns from nameoftable query.