/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 vote330 views1 answer
Online sql testing tool
SQL
46 votes397 views4 answers
Create column sql
SQL
8 votes346 views1 answer
Sql limit results returned
SQL
1 vote346 views1 answer
Psql search table
SQL
3 votes353 views2 answers
Postgres download
SQL
0 vote368 views1 answer
Python sql last insertend
SQL
1 vote346 views1 answer
Mysql check if string contains comma separated
SQL
5 votes343 views2 answers
Oracle apex debug mode
SQL
1 vote346 views1 answer
Mysql show attributes of a table
SQL
9 votes346 views1 answer
Mysql check date range
SQL