/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 vote231 views1 answer
Datetime postgres typeorm
SQL
0 vote231 views2 answers
Sql query for getting details by id
SQL
1 vote213 views1 answer
How to see all table partition in oracle
SQL
0 vote242 views1 answer
Get clob size oracle
SQL
0 vote250 views4 answers
Restart MySQL
SQL
0 vote217 views1 answer
Multiple left join mysql
SQL
0 vote232 views1 answer
Oracle current timestamp insert statement
SQL
7 votes225 views4 answers
Database dump mysql command
SQL
1 vote235 views1 answer
Create another table from existing table sql oracle
SQL
0 vote217 views1 answer
Create table if not exist with exceptions
SQL