/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 vote354 views1 answer
PSQL qith variables
SQL
8 votes467 views1 answer
Mysql dump restore
SQL
37 votes366 views3 answers
Duplicate records in sql
SQL
2 votes375 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote351 views1 answer
Mysql select month and year
SQL
1 vote349 views1 answer
Mysql Case sum
SQL
27 votes382 views5 answers
Mysql set password for user
SQL
0 vote344 views2 answers
Show slave status mysql
SQL
0 vote341 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote375 views1 answer
Oracle session statistics
SQL