· 8 years ago · Mar 14, 2018, 06:16 PM
1IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =
2OBJECT_ID(N'[dbo].[Tags]') AND type in (N'U'))
3Begin
4CREATE TABLE [dbo].[Tags] (
5 [Id] [bigint] IDENTITY(1,1) Primary Key NOT NULL,
6 [Name] [nvarchar](63) NOT NULL,
7 CONSTRAINT AK_TagName UNIQUE(Name))
8End