/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 vote163 views1 answer
Hex string sql becomes int64
SQL
0 vote154 views1 answer
Get employees if not contains in sql
SQL
0 vote154 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote150 views1 answer
Update having mysql
SQL
1 vote155 views1 answer
Table information in sql server
SQL
22 votes189 views1 answer
Mysql workbench
SQL
0 vote140 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote151 views1 answer
Groupby error in mysql
SQL
1 vote212 views1 answer
Pgsql sum switch case
SQL
2 votes146 views1 answer
Scaffold npgsql net core
SQL