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 vote127 views1 answer
Group_concat max length mysql
SQL
0 vote124 views1 answer
Where case insensitive like mysql
SQL
0 vote99 views1 answer
Mysql timeout 30 seconds
SQL
13 votes128 views2 answers
Mysql order by multiple columns
SQL
0 vote134 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote144 views1 answer
How to get one year old query from plan cache
SQL
8 votes143 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote150 views1 answer
Php select data from mysql database without column name
SQL
3 votes124 views2 answers
Oracle sql select all days between two dates except weekends
SQL
2 votes133 views1 answer
How to select first row of database sql
SQL