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 vote153 views1 answer
Example of sql querry result sepapreted by comma
SQL
12 votes117 views2 answers
Delete all data in neo4j
SQL
5 votes132 views1 answer
Get column name sql server
SQL
0 vote125 views1 answer
Mysql to get column name in database
SQL
-1 vote153 views1 answer
Search all sql tables for a value
SQL
0 vote117 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote143 views1 answer
Postgres get database encoding
SQL
3 votes162 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
3 votes127 views1 answer
Oracle transaction commit rollback example
SQL
19 votes125 views5 answers
Change column name mysql command line
SQL