sql select from all tables code example

Example 1: sql select all from table

SELECT * FROM tableName;

Example 2: select all tables sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'