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 |
