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 |