System Tables Views MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Tables Views
  4. Query sys databases for database name
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