select all from a table in sql 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'