/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 vote178 views1 answer
T-sql find object by name
SQL
0 vote166 views1 answer
Check index sql server
SQL
2 votes174 views1 answer
Sqlite show table indexes
SQL
7 votes212 views1 answer
Oracle alter sequence restart start with
SQL
1 vote130 views1 answer
Convert money to varchar sql server
SQL
50 votes262 views6 answers
Sql count duplicate rows
SQL
7 votes165 views1 answer
Safe mode mysql
SQL
10 votes197 views2 answers
Tsql merge example
SQL
1 vote165 views1 answer
Psql show with user is logged in
SQL
10 votes175 views5 answers
Between keyword in sql
SQL