Advertisement
MatthijsFontys

Create db if not exists

Nov 2nd, 2020
2,486
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.11 KB | None | 0 0
  1. IF NOT EXISTS (SELECT * FROM sys.DATABASES WHERE name = 'DbName')
  2. BEGIN
  3.   CREATE DATABASE DbName;
  4. END;
  5. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement