/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 vote380 views1 answer
Mssql find deadlocks
SQL
0 vote330 views2 answers
Mysql unique two columns
SQL
0 vote352 views1 answer
Sql multiple into
SQL
0 vote360 views1 answer
Datatables server side filter where clause
SQL
0 vote365 views1 answer
How to use sqlcommand
SQL
1 vote319 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote322 views1 answer
Get only structure database mysql
SQL
0 vote352 views1 answer
Java sql insert return id
SQL
0 vote346 views2 answers
Pop sql insert value into
SQL
1 vote322 views1 answer
Xampp import sql file command line
SQL