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

6 votes91 views3 answers
Mysql server is not starting xampp
SQL
0 vote114 views2 answers
How to type a blank discord messgae
SQL
1 vote101 views1 answer
Oracle create program if no exists
SQL
0 vote94 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote97 views1 answer
Partitioning in oracle-base
SQL
3 votes100 views2 answers
Current year sql
SQL
0 vote102 views1 answer
Find number of entries sql
SQL
1 vote98 views1 answer
Psql filed name alter
SQL
12 votes105 views2 answers
Delete entries in postgresql
SQL
6 votes112 views2 answers
Insert into select mysql
SQL