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

3 votes283 views1 answer
Postgresql today - 1 year
SQL
0 vote177 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
4 votes185 views4 answers
Rollback in sql
SQL
1 vote143 views1 answer
Oracle character set
SQL
0 vote176 views1 answer
Mariadb LOAD DATA INFILE
SQL
0 vote192 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote207 views1 answer
How to run mysql on terminal mac
SQL
17 votes252 views6 answers
Get last record in sql
SQL
0 vote195 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote185 views1 answer
How to check the port of mysql installation in mac
SQL