/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

1 vote131 views1 answer
Into sql
SQL
4 votes247 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
1 vote170 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
24 votes170 views6 answers
Sql change table name
SQL
2 votes167 views1 answer
Oracle drop table free up space
SQL
-1 vote181 views2 answers
Installing mysql on centos 7
SQL
21 votes169 views1 answer
Cheatsheet for sql
SQL
0 vote197 views1 answer
For row in sql database python loop
SQL
0 vote274 views1 answer
How to get all values in a table mysql in c#
SQL
3 votes196 views1 answer
Sql online test questions and answers
SQL