Microsoft/mssql2019. 5. 22. 15:32

show databases;

select name from sys.databases
go

[링크 : https://stackoverflow.com/questions/2087902/sqlserver-08-query-to-list-all-databases-in-an-instance]

 

 

use table_name

use table_name;

 

show tables;

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

[링크 : https://chartio.com/resources/tutorials/sql-server-list-tables-how-to-show-all-tables/]

'Microsoft > mssql' 카테고리의 다른 글

linux mssql odbc 예제  (0) 2021.10.22
mssql on docker  (0) 2021.10.22
mssql UDL 파일  (0) 2021.10.22
mssql import from csv  (0) 2019.07.25
Posted by 구차니