Sql show tables

Get the list of all tables in sql server

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

How to get all table names in sql query

BY LOVE SINGHSELECT 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;

Mariadb show tables

SHOW TABLES FROM database

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 vote291 views1 answer
Max length found in mysql
SQL
1 vote305 views1 answer
Sql how to replace full stop
SQL
6 votes263 views5 answers
Get current date sql
SQL
0 vote291 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote273 views2 answers
How to combine diff colmun value using group by postgres
SQL
2 votes282 views1 answer
Mysql application.properties spring boot
SQL
0 vote260 views2 answers
Cascade syntax in sql
SQL
1 vote253 views10 answers
Stack overflow
SQL
1 vote277 views1 answer
Events mysql
SQL
0 vote262 views2 answers
2nd max salary query in sql
SQL