X4k8uyDP

1IF NOT EXISTS (SELECT * FROM sys.objects 
2               WHERE object_id = OBJECT_ID(N'[dbo].[Tags]') 
3                 AND type in (N'U'))
4BEGIN
5    CREATE TABLE [dbo].[Tags] 
6    (
7        [Id] [bigint] IDENTITY(1,1) PRIMARY KEY NOT NULL,
8        [Name]  [nvarchar](63) NOT NULL,
9
10        CONSTRAINT AK_TagName UNIQUE(Name)
11    )
12END
13	
14CREATE TABLE [dbo].[Tags] (
15    [Id]    [bigint] IDENTITY(1,1) NOT NULL,
16    [Name]  [nvarchar](63) NOT NULL,
17    CONSTRAINT PK_Tag PRIMARY KEY NONCLUSTERED (Id ASC),
18    CONSTRAINT AK_TagName UNIQUE CLUSTERED (Name ASC)
19);