System Tables Views MSSQL Tutorial

3> USE master
4> GO
Changed database context to 'master'.
1>
2> SELECT name, is_auto_close_on
3> FROM sys.databases
4> GO
name                                                                                                                             is_auto_close_on
-------------------------------------------------------------------------------------------------------------------------------- ----------------
master                                                                                                                                          0
tempdb                                                                                                                                          0
model                                                                                                                                           0
msdb                                                                                                                                            0
ClubRoster                                                                                                                                      1
(5 rows affected)
1>