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

27 votes159 views6 answers
Sql update record
SQL
18 votes142 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote137 views1 answer
Set default value now() date
SQL
0 vote145 views1 answer
Wordpress sql change site url
SQL
2 votes165 views3 answers
Application.properties spring boot mysql
SQL
2 votes178 views2 answers
Null column to 0 in mysql
SQL
0 vote149 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
2 votes131 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote133 views1 answer
Order by oracle
SQL
14 votes154 views4 answers
Online sql compiler
SQL