Showing all table: show tables; Showing table data: SELECT * or column_names FROM table_name;
-- Oracle SELECT * FROM ALL_TABLES; -- MySQL SELECT * FROM INFORMATION_SCHEMA.TABLES;
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() and TABLE_NAME like'%table_name%'--to check particular table
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'