QD6u2Bec

1USE TestDB
2GO
3IF NOT EXISTS (
4   SELECT name
5   FROM sys.databases
6   WHERE name = N'TestDB'
7)
8CREATE DATABASE [TestDB]
9GO
10
11IF OBJECT_ID('Users', 'U') IS NOT NULL
12DROP TABLE Users
13GO
14
15CREATE TABLE Users
16(
17   UserID        INT    NOT NULL   PRIMARY KEY,
18   Login      [NVARCHAR](50)  NOT NULL,
19   Password  [NVARCHAR](50)  NOT NULL,
20);
21GO