/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 vote203 views1 answer
Replace null value within column mysql
SQL
0 vote190 views1 answer
Mssql describe stored procedure sqlcmd
SQL
0 vote154 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote169 views1 answer
Sql server sleep
SQL
7 votes154 views3 answers
Sql set
SQL
1 vote140 views1 answer
Sql update table remove spaces
SQL
0 vote132 views1 answer
Stuff in sql server
SQL
0 vote172 views2 answers
Oracle ora-00054 how to unlock
SQL
1 vote139 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
3 votes143 views1 answer
How to check schema privileges in oracle
SQL