Mega Code Archive
Categories
/
MSSQL Tutorial
/
System Tables Views
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