How to get all 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'

How to get all tables in sql

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

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'

How to check table name in current database sql

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG=db_name() 
and TABLE_NAME like'%table_name%'--to check particular table

Similar codes

3 votes155 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
3 votes138 views2 answers
How to start mysql in terminal
SQL
1 vote161 views2 answers
Sql where is not number
SQL
0 vote153 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote156 views3 answers
Mysqli count down
SQL
0 vote147 views1 answer
Oracle select partition
SQL
0 vote152 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
15 votes147 views6 answers
Psql
SQL
2 votes151 views1 answer
Apex execute batch job
SQL
0 vote140 views1 answer
Greater than or equal to symbol in postgres
SQL