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

0 vote292 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
5 votes320 views1 answer
Migrate sql table another database
SQL
0 vote389 views2 answers
Clauses in mysql
SQL
4 votes329 views3 answers
Sqlite show columns
SQL
0 vote392 views1 answer
Postgres - Login and connect as default user
SQL
0 vote363 views1 answer
Running mysql from bash sc
SQL
1 vote345 views1 answer
Top 10 rows in mysql
SQL
0 vote369 views1 answer
How to install sql in anaconda
SQL
0 vote373 views1 answer
Date 3 months from today sql
SQL
1 vote369 views1 answer
Base64 encode sql server
SQL