Microsoft/mssql
mssql sqlcmd
구차니
2019. 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/]