/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 vote152 views1 answer
Mysql update from n to 100
SQL
0 vote204 views1 answer
Fetching data from mysqldb
SQL
3 votes148 views1 answer
Mysql UPDate with enner join
SQL
0 vote157 views1 answer
Python mysql query to dataframe
SQL
3 votes180 views2 answers
Synonym oracle
SQL
13 votes151 views2 answers
Get tables in database sql
SQL
1 vote223 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
2 votes155 views2 answers
Spring where to put the data sql
SQL
1 vote171 views1 answer
Increase existing date in sql oracle
SQL
0 vote167 views1 answer
How to change mysql port in xampp
SQL