USE YOUR_DATABASE_NAME
SELECT *
FROM INFORMATION_SCHEMA.TABLES
SELECT *
FROM INFORMATION_SCHEMA.tables
where table_schema = 'public';
Showing all table:
show tables;
Showing table data:
SELECT
* or column_names
FROM
table_name;
select tablespace_name, table_name from all_tables;
USE 'DATABASE_NAME';
SHOW TABLES;