/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 vote298 views1 answer
VSCode SQL Server Connection error
SQL
0 vote299 views1 answer
Str_to_date sql server
SQL
1 vote302 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote324 views1 answer
Get current date in pyspark sql
SQL
0 vote319 views1 answer
Order child below the parent in mysqli
SQL
0 vote286 views1 answer
Min and max salary and name in sql
SQL
7 votes323 views2 answers
Mysql check db size
SQL
0 vote306 views1 answer
Sql shell psql cannot enter password
SQL
0 vote287 views1 answer
Login phpmyadmin without password
SQL
9 votes293 views4 answers
How to create new user and database postgresql in ubuntu
SQL