/SQL/Select all tables sql

Select all tables 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

How to get all tables in sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

2

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

Select all tables sql

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

0

Source: stackoverflow.com

Similar codes

0 vote112 views1 answer
Login failed for login due to trigger execution
SQL
0 vote128 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote119 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote128 views1 answer
To Create directory
SQL
0 vote123 views1 answer
Start and stop mysql
SQL
1 vote124 views1 answer
Sql select all from one table and one column from another
SQL
0 vote109 views1 answer
T sql check active deadlock
SQL
2 votes112 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote131 views2 answers
Sql stored procedure for access frontend
SQL
0 vote117 views1 answer
How to avoid duplicate records in sqlite
SQL

Share