/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 vote181 views2 answers
Add colum in sql
SQL
3 votes164 views1 answer
V$session not found in oracle
SQL
0 vote164 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote168 views1 answer
Update table sql multiple set
SQL
0 vote171 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote163 views1 answer
Show table status command in mysql
SQL
0 vote167 views1 answer
Sql developer format sql
SQL
0 vote173 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote174 views1 answer
Postgres first_value in gropby
SQL
6 votes172 views2 answers
Can't connect to local mysql server through socket
SQL