/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

5 votes361 views1 answer
How to get all dates in a month in oracle
SQL
11 votes351 views2 answers
Turn off safe mode mysql
SQL
1 vote378 views1 answer
Replace all numbers in mysql
SQL
0 vote364 views1 answer
How to to get time in sql
SQL
7 votes383 views2 answers
Mysql check db size
SQL
2 votes360 views3 answers
How to get second highest salary in each department in sql
SQL
2 votes367 views1 answer
Mysql application.properties spring boot
SQL
2 votes467 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes393 views2 answers
Mysql grant all privileges to user from any host
SQL
3 votes380 views2 answers
Mysql update row
SQL