/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

13 votes140 views3 answers
List all the tables in sql
SQL
0 vote106 views1 answer
Find invalid datetime field
SQL
0 vote114 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote104 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote113 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote111 views1 answer
Mysql to get column name in database
SQL
12 votes114 views1 answer
How to change the value of a table in sql
SQL
2 votes103 views1 answer
Oracle calculated column
SQL
0 vote97 views1 answer
Frename oracle
SQL
2 votes98 views1 answer
Postgresql change value in column
SQL