/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 votes286 views2 answers
Set value to null sql
SQL
0 vote260 views1 answer
How to move a columns location in mysql
SQL
1 vote280 views1 answer
Oracle create program if not exists
SQL
0 vote265 views1 answer
Postgresql inheritance
SQL
1 vote244 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote243 views1 answer
Postgresql define pk sequence next number
SQL
4 votes250 views2 answers
Mysql delete user if exists
SQL
7 votes241 views6 answers
Group_concat in mysql
SQL
2 votes295 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote233 views1 answer
Sql remove first character from string
SQL