/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

2 votes258 views3 answers
3 days back in sql server
SQL
0 vote257 views1 answer
Find largest table in mysql database
SQL
0 vote267 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote329 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes265 views4 answers
Inner join in update query mysql
SQL
8 votes285 views1 answer
Ltrim sql
SQL
0 vote271 views1 answer
Less mysql display
SQL
0 vote258 views1 answer
Where in clause tsql
SQL
0 vote259 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
4 votes266 views3 answers
Rename table column postgresql
SQL