/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 vote353 views1 answer
Postgresql how to show table names
SQL
0 vote335 views1 answer
Double in sql server example
SQL
4 votes332 views1 answer
T-sql get duplicate rows
SQL
8 votes336 views3 answers
Oracle auto_increment
SQL
0 vote319 views1 answer
Mysql default uuid
SQL
1 vote317 views1 answer
Sql select where id not exists in another table
SQL
0 vote344 views1 answer
Delete first row in sql
SQL
0 vote285 views1 answer
Sqlalchemy filter relationship
SQL
0 vote316 views1 answer
Select from 3 tables one is empty
SQL
0 vote311 views1 answer
Pl sql search saurce code
SQL