Question

How will you view all the tables in the database named company?

Answer 1

Well, the question is labelled for MySQL, I will answer this question for Oracle DB since other have answered for MySQL and SQL Server.

To view your tables or the ones that belongs to you:

SELECT * FROM user_tables;

To view all your tables and the tables that you have access to from other Schema(s):

SELECT * FROM all_users;

To View all the tables that are in your Oracle DB instance:

SELECT * from dba_users;

The last SELECT requires special privileges from DBA just in case the query didn’t work for you.