/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 vote128 views1 answer
Make parameters nullable in sql server
SQL
0 vote126 views1 answer
Get schema of table sql
SQL
5 votes121 views3 answers
Oracle first day of last year
SQL
-1 vote148 views2 answers
Sql search all tables for attributes
SQL
9 votes114 views2 answers
Sql limit order by
SQL
2 votes130 views1 answer
Mariadb json select
SQL
1 vote112 views1 answer
Mysql current time
SQL
0 vote106 views5 answers
Sql table intermédiaire
SQL
1 vote115 views1 answer
Sqlite check if row exists
SQL
21 votes111 views1 answer
Cheatsheet for sql
SQL