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

6 votes168 views2 answers
Can't connect to local mysql server through socket
SQL
-2 votes181 views2 answers
Union all in sql
SQL
0 vote202 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
12 votes161 views4 answers
SQL Where
SQL
0 vote190 views1 answer
To Create directory
SQL
0 vote160 views1 answer
Tsql delete all rows
SQL
0 vote173 views1 answer
Postgresql delete limit
SQL
10 votes178 views3 answers
Sql select between two dates
SQL
2 votes172 views2 answers
Mysql limit
SQL
0 vote178 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL