- Trending Categories
- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Environmental Science
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- articles and Answers
- Effective Resume Writing
- HR Interview articles
- Computer Glossary
- Who is Who
How can I see all tables in SQL?
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:
show tables;
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;
Advertisements
ads