/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 vote250 views1 answer
Mysql collation
SQL
0 vote306 views2 answers
How to get max from each department in sql
SQL
0 vote290 views1 answer
Php mysqli install
SQL
0 vote283 views1 answer
How to select all fieldsin a soql query
SQL
42 votes345 views6 answers
Sql query duplicate rows
SQL
1 vote254 views1 answer
Select not matching data from two tables
SQL
5 votes280 views1 answer
Sort order on two columns sql
SQL
0 vote270 views2 answers
Sql max count
SQL
0 vote272 views1 answer
Drop specific row postgresql
SQL
2 votes295 views3 answers
Sql truncate table
SQL