/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

3 votes122 views1 answer
Postgresql if null then 0
SQL
0 vote131 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote131 views1 answer
Oracle enable chain
SQL
0 vote125 views1 answer
Can we rollback deleted data in sql
SQL
12 votes124 views4 answers
Install mysql ubuntu 18.04
SQL
17 votes126 views4 answers
Sort by mysql
SQL
2 votes151 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote152 views1 answer
Mysql return text after a final full stop
SQL
1 vote126 views2 answers
Postgres cast as decimal
SQL
4 votes133 views3 answers
Employee name starting with in sql
SQL