/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

11 votes144 views1 answer
Get ddl materialized view oracle
SQL
3 votes185 views2 answers
Wp do sql query from function
SQL
1 vote201 views1 answer
Show databases mysql docker
SQL
0 vote144 views1 answer
Mysql identified by syntax error
SQL
1 vote140 views1 answer
Order by oracle
SQL
0 vote163 views1 answer
Mysql remove bad character from all fields
SQL
0 vote123 views0 answer
SQL
1 vote140 views1 answer
Mysql get character set
SQL
0 vote175 views1 answer
Sql remove decimal places
SQL
0 vote150 views1 answer
Set mysql socket file docker windows
SQL

Share