/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 vote159 views1 answer
Convert polygon to text in mysql
SQL
3 votes191 views3 answers
List columns in table postgres
SQL
0 vote159 views2 answers
Dbms interview questions
SQL
0 vote170 views1 answer
Postgressql uuid
SQL
0 vote157 views1 answer
How to locate pg_hba.conf file
SQL
4 votes149 views2 answers
Oracle last day of month
SQL
0 vote152 views2 answers
Laravel: customize or extend notifications - database model
SQL
10 votes130 views1 answer
Oracle dependency
SQL
0 vote190 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote105 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL