Show columns from table

Show table columns

-- MySQL
DESCRIBE tableName;
SHOW COLUMNS FROM tableName;

-- SQLite3
.schema tableName

Source: grepper.com

SHOW COLUMNS Statement

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

Source: dev.mysql.com

Show columns

Copied mysql> SHOW COLUMNS FROM City;
+------------+----------+------+-----+---------+----------------+
| Field      | Type     | Null | Key | Default | Extra          |
+------------+----------+------+-----+---------+----------------+
| Id         | int(11)  | NO   | PRI | NULL    | auto_increment |
| Name       | char(35) | NO   |     |         |                |
| Country    | char(3)  | NO   | UNI |         |                |
| District   | char(20) | YES  | MUL |         |                |
| Population | int(11)  | NO   |     | 0       |                |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

Source: dev.mysql.com

Show columns

mysql> SHOW COLUMNS FROM City;
+-------------+----------+------+-----+---------+----------------+
| Field       | Type     | Null | Key | Default | Extra          |
+-------------+----------+------+-----+---------+----------------+
| ID          | int(11)  | NO   | PRI | NULL    | auto_increment |
| Name        | char(35) | NO   |     |         |                |
| CountryCode | char(3)  | NO   | MUL |         |                |
| District    | char(20) | NO   |     |         |                |
| Population  | int(11)  | NO   |     | 0       |                |
+-------------+----------+------+-----+---------+----------------+

Source: dev.mysql.com

Similar codes

0 vote166 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote184 views1 answer
Case when with count and combining similar values in sql
SQL
1 vote182 views1 answer
Random name function in mysql for nvarchar
SQL
2 votes168 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote178 views1 answer
Groupby error in mysql
SQL
3 votes180 views3 answers
Create a view postgres
SQL
0 vote176 views1 answer
Reset postgresql password windows
SQL
2 votes208 views1 answer
Sql string starts with
SQL
0 vote179 views3 answers
Run sql command line
SQL
18 votes155 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL