Computer Science, asked by prakashchetri6pe5phb, 1 year ago

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

Answers

Answered by Rehan951
4
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.

Similar questions