/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 vote142 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote178 views1 answer
"Hello User Name"
SQL
19 votes164 views5 answers
Date between in mysql
SQL
0 vote146 views1 answer
Add column not null with default value postgres
SQL
0 vote172 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote157 views1 answer
Mysql show create db
SQL
0 vote148 views1 answer
Enable full text search mysql
SQL
-1 vote108 views3 answers
Ubuntu install mssql
SQL
1 vote153 views2 answers
Mysql: command not found
SQL
0 vote171 views1 answer
Mysql bind-address default value
SQL