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 vote147 views3 answers
Update from select sqlite
SQL
3 votes129 views2 answers
Laravel tosql with bindings
SQL
0 vote132 views1 answer
Access refused mysql xampp server
SQL
4 votes140 views1 answer
Wildcard in sql
SQL
1 vote127 views1 answer
Reutrn string after character sql
SQL
18 votes101 views2 answers
How to get all the tables displayed in oracle
SQL
24 votes139 views4 answers
Postgres remove database
SQL
13 votes131 views6 answers
Restart postgresql
SQL
3 votes142 views2 answers
Order by postgresql
SQL
0 vote174 views1 answer
Create table as select sql server error
SQL