/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

2 votes218 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote221 views1 answer
Rename view mysql
SQL
0 vote211 views1 answer
Fill up postgres db
SQL
1 vote225 views2 answers
Sql for date greater than
SQL
1 vote211 views2 answers
Oracle list partitioned tables
SQL
0 vote234 views3 answers
Duplicate row mysql
SQL
0 vote210 views1 answer
How to check which sp is running in sql server
SQL
0 vote211 views7 answers
10 random questions use python and SQL
SQL
0 vote235 views1 answer
Count database access django
SQL
0 vote206 views1 answer
Mysql to get column name in database
SQL