Different database management systems have different queries to see all the tables.
To see all the tables in MYSQL, we would have to use this query:
This is how we can see all tables in ORACLE:
SELECT table_name FROM User_tables;
This is how we can extract all tables in SQL Server:
SELECT * FROM Information_schema.tables;