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 vote200 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote186 views1 answer
What is SQL data store?
SQL
29 votes224 views6 answers
Delete all rows from table mysql
SQL
0 vote198 views2 answers
Timing sql queries
SQL
10 votes180 views6 answers
Mysql delete duplicates
SQL
-1 vote185 views1 answer
Round up and down sql
SQL
5 votes231 views1 answer
Mysql created at yesterdau
SQL
50 votes296 views6 answers
Sql count duplicate rows
SQL
21 votes203 views4 answers
Add column mssql
SQL
0 vote180 views1 answer
Output table plsql
SQL