/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

0 vote132 views10 answers
John the ripper mysql
SQL
2 votes110 views5 answers
Tablespace ORACLE
SQL
4 votes68 views1 answer
Oracle sleep
SQL
1 vote124 views1 answer
T-sql disable system versioning
SQL
0 vote110 views1 answer
ORA-13717
SQL
6 votes117 views1 answer
How to count number of rows in sql
SQL
0 vote102 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote115 views2 answers
T sql null or empty string
SQL
4 votes105 views2 answers
Oracle default date format
SQL
14 votes120 views2 answers
Oracle add attribute to table
SQL

Share