/SQL/List all the tables in sql

List all the tables in sql

Get the list of all tables in sql server

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

13

Sql query to list all tables in a database sql server

BY LOVE SINGH on May 19 2020SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

0

List all the tables in sql

select tablespace_name, table_name from all_tables;

0

Source: quora.com

Similar codes

0 vote193 views1 answer
Mariadb number format
SQL
4 votes242 views1 answer
How to drop a database in sql server when it is in use
SQL
17 votes261 views6 answers
MySQL ORDER BY
SQL
2 votes218 views2 answers
Create temporary table in mysql
SQL
0 vote193 views1 answer
Authentication in sql server
SQL
0 vote280 views2 answers
Install phoenix
SQL
0 vote272 views1 answer
Mysql row generator
SQL
0 vote194 views1 answer
How to to get current date and time in sql
SQL
0 vote218 views2 answers
Transaction php
SQL
4 votes199 views1 answer
Restart for pg_hba.conf file
SQL

Share