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 vote262 views2 answers
Android sqlite query join
SQL
9 votes282 views4 answers
Postgresql export database
SQL
0 vote271 views1 answer
What is SQL data store?
SQL
0 vote249 views1 answer
Oracle last connection
SQL
0 vote260 views1 answer
Postgresql delete multiple rows
SQL
1 vote267 views1 answer
SQLite order random
SQL
0 vote261 views1 answer
Mysql get last 2 month data
SQL
12 votes250 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote269 views1 answer
Mysql terminal run sql file
SQL
3 votes252 views1 answer
Delete all content in table mysql
SQL