How will you view all the tables in the database named company?
Answers
Answered by
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.
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