1SET ANSI_NULLS ON
 2GO
 3SET QUOTED_IDENTIFIER ON
 4GO
 5IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Article]') AND type in (N'U'))
 6BEGIN
 7CREATE TABLE [dbo].[Article](
 8    [ID] [int] IDENTITY(1,1) NOT NULL,
 9    [CategoryID] [int] NOT NULL,
10    [ArticleName] [nvarchar](50) NULL,
11    [ArticleContent] [ntext] NULL,
12    [Date] [smalldatetime] NULL,
13 CONSTRAINT [PK_Article] PRIMARY KEY CLUSTERED 
14(
15    [ID] ASC
16)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
17) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
18END
19GO
20SET ANSI_NULLS ON
21GO
22SET QUOTED_IDENTIFIER ON
23GO
24IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Categories]') AND type in (N'U'))
25BEGIN
26CREATE TABLE [dbo].[Categories](
27    [ID] [int] IDENTITY(1,1) NOT NULL,
28    [CategoryName] [nvarchar](50) NULL,
29 CONSTRAINT [PK_Categories] PRIMARY KEY CLUSTERED 
30(
31    [ID] ASC
32)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
33) ON [PRIMARY]
34END
35