SQL Server/T-SQL Tutorial/System Tables Views/sys.databases

Query sys.databases

   <source lang="sql">

3> USE master 4> GO Changed database context to "master". 1> 2> DECLARE @DBName nvarchar(128) 3> DECLARE @TBLName nvarchar(128) 4> SET @DBName = N"Northwind" 5> SET @TBLName = N"Shippers" 6> 7> 8> 9> SELECT name 10> FROM sys.databases 11> WHERE name = @DBName 12> GO name

---

(0 rows affected) 1> SELECT name, object_id 2> FROM sys.tables 3> WHERE name = @TBLName 4> GO Msg 137, Level 15, State 2, Server J\SQLEXPRESS, Line 3 Must declare the scalar variable "@TBLName".</source>

Query sys.databases for database name

   <source lang="sql">

10> USE master 11> GO 13> IF EXISTS(SELECT name FROM sys.databases 14> WHERE name = N"NewDB") 15> DROP DATABASE NewDB 16> GO 17> 18> CREATE DATABASE NewDB 19> GO 21> USE NewDB 22> GO</source>

SELECT name, is_auto_close_on FROM sys.databases

   <source lang="sql">

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></source>