/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

-1 vote100 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote236 views1 answer
Dublicate row sql
SQL
103 votes258 views1 answer
Like sql
SQL
0 vote115 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
7 votes105 views4 answers
Mysql delete older duplicates
SQL
0 vote126 views1 answer
Update sql sintax
SQL
0 vote149 views1 answer
Add user mysql wordpress
SQL
1 vote122 views1 answer
Psql connect
SQL
0 vote109 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
9 votes100 views2 answers
Sql server check table exists
SQL