Advertisement
Guest User

Untitled

a guest
Jan 26th, 2020
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. DECLARE @dbname nvarchar(128)
  2. SET @dbname = N'School';
  3.  
  4. IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname))
  5. BEGIN
  6.     DROP DATABASE School;
  7. END
  8.  
  9. CREATE DATABASE School;
  10. GO
  11. USE School;
  12. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement