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 버전 확인 쿼리  (0) 2019.07.30
mssql import from csv  (0) 2019.07.25
Posted by 구차니