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

2 votes311 views1 answer
Revokeprivileges mysql
SQL
4 votes293 views1 answer
Phone number sql
SQL
9 votes316 views4 answers
Postgresql export database
SQL
3 votes326 views2 answers
Synonym oracle
SQL
0 vote303 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote293 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
16 votes283 views2 answers
Oracle ddl
SQL
0 vote294 views1 answer
Executescalar in sql server
SQL
1 vote328 views1 answer
Oracle create program if not exists
SQL
1 vote273 views1 answer
Sql get all columns from one table but one from another inner join
SQL