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

2 votes194 views1 answer
Q operator in plsql
SQL
13 votes179 views2 answers
Check if value is null mysql
SQL
0 vote192 views1 answer
Postgresql auto increment not working
SQL
0 vote200 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote192 views1 answer
Mariadb set vertical output format
SQL
0 vote172 views1 answer
Eliminar ultimo carcacter mysql
SQL
4 votes187 views5 answers
Primary key
SQL
0 vote167 views1 answer
Sql requete number pair
SQL
3 votes164 views1 answer
Mysql UPDate with enner join
SQL
1 vote210 views1 answer
Postgresql append array
SQL