/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 vote159 views1 answer
Sql query to return field name of a table
SQL
0 vote151 views1 answer
Sql select random procentage from rows
SQL
0 vote138 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote141 views1 answer
Get all employees if name ends with in sql
SQL
7 votes145 views2 answers
Oracle sql drop index
SQL
2 votes152 views2 answers
How to run postgresql in linux
SQL
1 vote163 views1 answer
Nvl postgres
SQL
0 vote137 views1 answer
How to install postgresql on wsl
SQL
0 vote133 views1 answer
Sql select most frequent value in group
SQL
7 votes141 views2 answers
Mysql get year from date
SQL