/SQL/Show tables sql server

Show tables sql server

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'

13

Show tables sql server

USE YOUR_DATABASE_NAME
SELECT *
FROM INFORMATION_SCHEMA.TABLES

2

Sql show tables

Showing all table: 
show tables;

Showing table data:
SELECT
* or column_names
FROM
table_name;

2

Sql query to list all tables in a database sql server

BY LOVE SINGH on May 19 2020SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'

0

Similar codes

2 votes136 views1 answer
Get first 2 letter in sql
SQL
1 vote133 views1 answer
Oracle truncate partition
SQL
1 vote137 views1 answer
Substr sql last character
SQL
1 vote128 views2 answers
Sql example query
SQL
0 vote152 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote142 views1 answer
Ignore case in string sql
SQL
1 vote150 views1 answer
Error code 1292 mysql workbench
SQL
0 vote137 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote147 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote177 views2 answers
Clauses in mysql
SQL

Share