/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

1 vote277 views1 answer
Oracle avg
SQL
2 votes280 views1 answer
Sql to char function with date
SQL
5 votes266 views2 answers
Oracle tables with column name
SQL
0 vote273 views1 answer
Postgres sql alter table delete row
SQL
0 vote288 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote276 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
2 votes266 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote258 views1 answer
Strat with in sql
SQL
0 vote283 views1 answer
Sqlcmd no headers
SQL
0 vote288 views1 answer
Find duplicate users by email address in mysql
SQL