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