/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

1 vote205 views1 answer
Limit offset order by mysql
SQL
0 vote200 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote161 views0 answer
SQL
0 vote184 views1 answer
Drop column from local database postgres pgadmin
SQL
1 vote186 views1 answer
Oracle stop job
SQL
24 votes173 views4 answers
How to add column sql
SQL
1 vote191 views1 answer
SQL Integer devision
SQL
0 vote169 views1 answer
Find usage of table in sql server
SQL
1 vote171 views1 answer
Oracle select first result
SQL
1 vote167 views1 answer
Order by oracle
SQL