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 vote115 views1 answer
Sql server get date of previous sunday
SQL
0 vote129 views1 answer
Create database like
SQL
3 votes146 views1 answer
How to add unique constraint in mysql table
SQL
-1 vote116 views1 answer
Can pandas fetch data from sql
SQL
1 vote124 views1 answer
Flask sqlalchemy default value
SQL
0 vote126 views1 answer
Mysql get first 2 characters of string
SQL
16 votes115 views2 answers
Sql exists
SQL
5 votes108 views2 answers
Add column postgres with default value
SQL
0 vote115 views2 answers
Postgres having
SQL
1 vote122 views1 answer
Name of today sql
SQL