show table columns

1-- MySQL
2DESCRIBE tableName;
3SHOW COLUMNS FROM tableName;
4
5-- SQLite3
6.schema tableName

1DESCRIBE table1;
2
3-- result:
4+----------------------+---------------------------+------+-----+-------------------+
5| Field                | Type                      | Null | Key | Default           | Extra                                         |
6+----------------------+---------------------------+------+-----+-------------------+
7| film_id              | smallint(5) unsigned      | NO   |     | 0                 |                                               |
8| title                | varchar(128)              | NO   |     | NULL              |                                               |
9| description          | text                      | YES  |     | NULL              |                                               |
10| release_year         | year(4)                   | YES  |     | NULL              |                                               |
11| language_id          | tinyint(3) unsigned       | NO   |     | NULL              |                                               |
12| original_language_id | tinyint(3) unsigned       | YES  |     | NULL              |                                               |
13| rental_duration      | tinyint(3) unsigned       | NO   |     | 3                 |                                               |
14| rental_rate          | decimal(4,2)              | NO   |     | 4.99              |