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 vote183 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote173 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote255 views1 answer
Microsoft sql server python connection
SQL
4 votes186 views5 answers
Primary key
SQL
0 vote195 views1 answer
Kotlin sqlite delete row
SQL
0 vote228 views1 answer
Mql5 datetime get hour
SQL
-1 vote185 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote198 views1 answer
Command line mysql xampp
SQL
0 vote189 views1 answer
Sqlalchemy get ids
SQL
1 vote188 views1 answer
Show table status command in mysql
SQL