/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 vote335 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
4 votes335 views1 answer
Check database name postgresql
SQL
0 vote332 views1 answer
The local psql command could not be located
SQL
0 vote403 views1 answer
Copy row from db to db mysql
SQL
12 votes342 views5 answers
Sql merge
SQL
14 votes341 views3 answers
SQL trim
SQL
0 vote356 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote334 views2 answers
Mysql to python pandas
SQL
3 votes352 views2 answers
Plsql print
SQL
8 votes353 views1 answer
Sql limit results returned
SQL