/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 votes240 views1 answer
Sql server: select column values as comma separated string
SQL
1 vote202 views1 answer
Select random sample sql
SQL
1 vote232 views1 answer
Nvl postgres
SQL
0 vote242 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
1 vote193 views1 answer
Get last week data in mysql
SQL
3 votes190 views2 answers
Oracle grants
SQL
3 votes232 views3 answers
Create table in SQL Server
SQL
0 vote198 views2 answers
Create sequence if not exists postgres
SQL
16 votes190 views2 answers
Gremove folder from git
SQL
1 vote178 views1 answer
Select dba users oracle
SQL