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

6 votes222 views1 answer
Postgres get size of database
SQL
0 vote215 views1 answer
Mysql disable query caching
SQL
0 vote182 views1 answer
Mysql timeout 30 seconds
SQL
0 vote280 views1 answer
What is common table expression in sql
SQL
1 vote208 views1 answer
Mysql random limit 1
SQL
0 vote221 views1 answer
Odd record sql query
SQL
18 votes221 views4 answers
Uninstall mysql ubuntu 18.04
SQL
11 votes234 views3 answers
Sql_mode=only_full_group_by
SQL
3 votes201 views1 answer
Mysql UPDate with enner join
SQL
1 vote198 views1 answer
Reutrn string after character sql
SQL