/SQL/How to check table name in current database sql

How to check table name in current database sql

How to get all table names in sql query

BY LOVE SINGH

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_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 vote208 views1 answer
Sql #region
SQL
6 votes212 views1 answer
Oracle rank
SQL
0 vote199 views1 answer
Composit key in sql
SQL
1 vote244 views2 answers
Install sql server management studio ubuntu
SQL
2 votes204 views2 answers
Select list is not in group by clause
SQL
5 votes199 views2 answers
Oracle tables with column name
SQL
0 vote200 views1 answer
Fix sqlite3 ruby on rails
SQL
1 vote200 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
1 vote194 views1 answer
Select statement to print longest name
SQL
0 vote191 views5 answers
Linq cheat sheet
SQL