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.

Show Columns From Nameoftable

Show Columns From items

“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.