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

2 votes289 views1 answer
Mysql find tables with name
SQL
1 vote319 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote304 views1 answer
Sql server check whether column has same equal values
SQL
0 vote310 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote321 views1 answer
Sql max of two values
SQL
1 vote314 views2 answers
Oracle create synonym
SQL
-1 vote331 views2 answers
Sql search all tables for attributes
SQL
0 vote285 views1 answer
Mysql date time string format python
SQL
0 vote301 views1 answer
Create table as select sql server error
SQL
5 votes293 views1 answer
Sql check if date is between 2 dates
SQL