SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
BY LOVE SINGH SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
Showing all table: show tables; Showing table data: SELECT * or column_names FROM table_name;
SHOW TABLES FROM database
-- 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