/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 vote234 views1 answer
Mysql c commands
SQL
12 votes223 views6 answers
Distinct in sql server
SQL
11 votes194 views2 answers
Insert current date sql
SQL
0 vote225 views1 answer
Eliminate zero from integer mysql
SQL
1 vote192 views2 answers
Group_concat limit mysql
SQL
0 vote202 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes173 views2 answers
How to create an empty table from an existing table
SQL
-1 vote197 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote220 views1 answer
Mysql conf.d exampel
SQL
3 votes332 views2 answers
Oracle sql first day of month
SQL