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

7 votes144 views2 answers
Execute mysql file
SQL
1 vote133 views1 answer
Postgres grant read only access to database
SQL
0 vote149 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote145 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote155 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
0 vote130 views1 answer
Remove from table where
SQL
1 vote145 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
6 votes136 views2 answers
If not exists insert sql
SQL
2 votes132 views1 answer
When matched in sql server
SQL
13 votes139 views2 answers
Oracle select into and inner join
SQL