/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 vote243 views1 answer
Get created time of database psql 8
SQL
1 vote262 views1 answer
Sysdate in sql
SQL
0 vote261 views1 answer
Mysql Like(searching in the string)
SQL
3 votes263 views2 answers
Sql end of month
SQL
18 votes257 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote272 views1 answer
Sql pivot table
SQL
1 vote256 views2 answers
Mysql insert generate serie
SQL
0 vote244 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
8 votes299 views2 answers
Default sql server port
SQL
1 vote282 views2 answers
Mysql extract number from string
SQL