/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

20 votes197 views4 answers
Reset auto increment in MySQL
SQL
0 vote193 views1 answer
Linked server delete openquery
SQL
8 votes275 views1 answer
Insert a select statement into a table
SQL
15 votes179 views4 answers
Mysql where value is null
SQL
0 vote182 views1 answer
Sql: extract day text from datetime value
SQL
4 votes190 views1 answer
Oracle error line
SQL
8 votes179 views2 answers
Mysql query dates between two dates
SQL
-1 vote160 views1 answer
Mysql if example
SQL
7 votes174 views3 answers
Add primary key to database sql
SQL
0 vote188 views1 answer
Oracle array
SQL