List all columns in a table sql server

---

---

MySQL Show Columns Statement

To retrieve entire information of a table, we use DESCRIBE, DESC or SHOW COLUMNS statements.

All of these statements of MySQL can be used to retrieve/display the description of all the columns of a table, as they all retrieve the same result-sets.

Obtaining column information can be useful in several situations like inserting values into a table (based on the column datatype), updating or dropping a column, or to just simply know a table's structure.

In this chapter, let us understand how to use SHOW COLUMNS statement in detail.

Syntax

Following is the syntax of the MySQL SHOW COLUMNS Statement −

SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]

Example

Let us start with creating a database named TUTORIALS using the below query −

CREATE DATABASE TUTORIALS;

Execute the following statement to change into TUTORIALS database −

USE TUTORIALS;

In the following query, we are creating a table named CUSTOMERS using the following CREATE TABLE s

show columns of table snowflake

show columns of table sqlite