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 vote326 views2 answers
Wordpress change url in database
SQL
2 votes306 views1 answer
Sqlite show table indexes
SQL
0 vote335 views2 answers
Imageview setimageresource null
SQL
2 votes325 views1 answer
Add new column not null sql server
SQL
0 vote369 views1 answer
Mysql workbench format date
SQL
1 vote385 views1 answer
Sql select row with max date
SQL
0 vote338 views1 answer
Change filed order in mysql
SQL
1 vote316 views1 answer
Importance of comment in mysql
SQL
4 votes342 views4 answers
What is primary key
SQL
1 vote346 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL