/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 vote144 views3 answers
Magento 2 order delete from db
SQL
4 votes153 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote112 views1 answer
Separator mysql
SQL
1 vote135 views1 answer
Mariadb case switch
SQL
2 votes134 views1 answer
How to search table name in stored procedure in sql server
SQL
20 votes144 views6 answers
Mysql reset auto increment
SQL
1 vote126 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote145 views1 answer
T-SQL - Where Used List (Table/View)
SQL
0 vote149 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote134 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL