How can I see all tables in SQL?

DatabaseDBMSSQL

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;
     
Updated on 14-Dec-2021 17:13:39

2 Views

Previous Page Print Page Next Page  
Advertisements

ads