Sql Show Columns

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.

---