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 vote201 views5 answers
Sql table intermédiaire
SQL
1 vote218 views1 answer
Drop column if exists sql server
SQL
1 vote204 views1 answer
Sql server cast date dd/mm/yyyy
SQL
1 vote198 views1 answer
Psql client write to bash variable
SQL
0 vote202 views1 answer
Big table in mysql
SQL
0 vote239 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote194 views1 answer
Truncate a table then insert data
SQL
7 votes220 views3 answers
Postgresql dump and restore db
SQL
0 vote210 views1 answer
Mysql conf.d exampel
SQL
1 vote203 views1 answer
Count mysql server db tables
SQL