query to see columns in a table sql code example

Example 1: get table columns from sql

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = N'Customers' 
-- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database
-- "N" defines the subsequent string (the string after the N) as being in unicode

Example 2: How to View column names of a table in SQL

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Example 3: sql show columns in table

DESCRIBE table1;

-- result:
+----------------------+---------------------------+------+-----+-------------------+
| Field                | Type                      | Null | Key | Default           | Extra                                         |
+----------------------+---------------------------+------+-----+-------------------+
| film_id              | smallint(5) unsigned      | NO   |     | 0                 |                                               |
| title                | varchar(128)              | NO   |     | NULL              |                                               |
| description          | text                      | YES  |     | NULL              |                                               |
| release_year         | year(4)                   | YES  |     | NULL              |                                               |
| language_id          | tinyint(3) unsigned       | NO   |     | NULL              |                                               |
| original_language_id | tinyint(3) unsigned       | YES  |     | NULL              |                                               |
| rental_duration      | tinyint(3) unsigned       | NO   |     | 3                 |                                               |
| rental_rate          | decimal(4,2)              | NO   |     | 4.99              |