/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 vote300 views1 answer
Backup a table in sql
SQL
0 vote309 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote333 views1 answer
Psql connect
SQL
0 vote330 views1 answer
Sql count * vs count 1
SQL
0 vote330 views2 answers
Mysql decimal remove trailing zeros
SQL
1 vote331 views1 answer
Mysql alter decimal precision
SQL
3 votes325 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote331 views1 answer
Foreign key type uniqu mysql
SQL
0 vote296 views1 answer
Selects all the columns from the sailors table
SQL
0 vote270 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL