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 vote429 views1 answer
Play framework connection via windows sql server
SQL
1 vote319 views1 answer
Primary key reset in SQL database
SQL
1 vote345 views3 answers
Union in sql
SQL
0 vote365 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote353 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote326 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote334 views1 answer
Python mysql executemany
SQL
10 votes317 views3 answers
Sql limit results
SQL
0 vote335 views1 answer
Insert into select with group by
SQL
0 vote320 views1 answer
Search db for table name
SQL