/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 vote271 views1 answer
Pl sql search saurce code
SQL
3 votes321 views1 answer
Where id is in list sql
SQL
2 votes301 views2 answers
Storing timezones in postgres
SQL
3 votes281 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
2 votes272 views3 answers
Replace null in sql
SQL
-2 votes280 views1 answer
Create trigger syntax
SQL
1 vote276 views1 answer
Create table variable in sql stored procedure
SQL
0 vote282 views1 answer
Load utilities in sql server
SQL
0 vote302 views1 answer
How to print some string in mysql
SQL
1 vote287 views1 answer
Select not matching data with join table
SQL