/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 vote191 views1 answer
Create function syntax sql server
SQL
1 vote192 views3 answers
Sql select only time from datetime
SQL
3 votes221 views3 answers
Update con select postgresql
SQL
0 vote201 views1 answer
Oracle session statistics
SQL
0 vote196 views1 answer
Get clob size oracle
SQL
13 votes151 views2 answers
Oracle all source
SQL
0 vote212 views1 answer
How to select even id in sql
SQL
0 vote266 views1 answer
Manage Database in MySQL
SQL
0 vote249 views1 answer
Sql from null to not null
SQL
0 vote197 views1 answer
Contact mysql column field
SQL

Share