/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 votes325 views2 answers
Sqlalchemy filter or
SQL
0 vote296 views1 answer
SQL isnumeric DB2
SQL
3 votes310 views1 answer
Créer une table sql
SQL
2 votes307 views2 answers
How to DROP a table in mysql
SQL
2 votes290 views1 answer
Sql select min value from multiple columns
SQL
1 vote320 views3 answers
Divide by zero error in sql
SQL
0 vote343 views1 answer
Get last inserted primary key
SQL
0 vote329 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote323 views2 answers
Starts and end with vowel sql
SQL
3 votes287 views3 answers
Mysql select table names
SQL