/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 votes122 views1 answer
Mysql virtual column
SQL
0 vote116 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
2 votes223 views1 answer
Sql ends with string
SQL
3 votes131 views2 answers
See mysql users ubuntu
SQL
0 vote133 views1 answer
How get data from database if id not found then search another column
SQL
1 vote121 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote204 views1 answer
Mssql unique key accept nulls
SQL
0 vote131 views3 answers
How to assign custom id in mysql
SQL
0 vote135 views1 answer
Postgressql uuid
SQL
4 votes130 views1 answer
Wilayah indonesia sql
SQL