/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

17 votes190 views5 answers
Order by sql
SQL
10 votes177 views2 answers
Mysql drop database if exists
SQL
0 vote183 views1 answer
Alter rename command in mysql
SQL
1 vote228 views1 answer
How to get alternate records from a table in sql
SQL
0 vote189 views1 answer
Change filed order in mysql
SQL
-1 vote210 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote203 views1 answer
How to find symmetric pairs in sql
SQL
5 votes212 views1 answer
How to check port number for postgresql
SQL
92 votes2.3K views6 answers
Substring
SQL
0 vote180 views1 answer
Find the names of sailors who have reserved at least one boat
SQL

Share