select from all tables using information_schema.tables code example

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

DESCRIBE Table_Name;

OR 

DESC Table_Name;

Example 2: get all columns from table sql

SELECT
  	TABLE_NAME
FROM
  	INFORMATION_SCHEMA.TABLES