/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 vote160 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote148 views1 answer
Sql server query database space available
SQL
0 vote151 views1 answer
Sql character index
SQL
1 vote143 views1 answer
Oracle stop job
SQL
2 votes149 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote150 views1 answer
Mysql add root password
SQL
4 votes132 views2 answers
Postgresql reset sequence
SQL
9 votes161 views5 answers
Laravel to sql
SQL
0 vote146 views2 answers
Starting mysql service from mac
SQL
0 vote150 views1 answer
Mysql backup certain tables workbench
SQL