/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 vote197 views3 answers
How to filter repeated same result using sql query
SQL
0 vote197 views1 answer
Python mysql query where
SQL
0 vote219 views1 answer
Sql revert migration
SQL
2 votes289 views1 answer
Create mysql user on all hosts
SQL
0 vote196 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote239 views1 answer
Postgresql on conflict pair
SQL
0 vote198 views1 answer
Authentication in sql server
SQL
0 vote229 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote189 views1 answer
Sql gather statistics to increase performance
SQL
0 vote207 views1 answer
Get the previous column of a table in mysql
SQL