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

-1 vote385 views5 answers
Left join
SQL
5 votes411 views4 answers
SQL Order of execution
SQL
0 vote365 views1 answer
Mysql query problems and solutions
SQL
1 vote344 views1 answer
Mysql server does not start mac
SQL
0 vote379 views1 answer
Oracle drop type
SQL
0 vote346 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote344 views1 answer
Create table if not exist with exceptions
SQL
0 vote360 views1 answer
Opensuse stop MySQL
SQL
0 vote344 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
1 vote349 views2 answers
Mysql type conversion
SQL