1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[deps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 2drop table [dbo].[deps]
 3GO
 4
 5if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[emps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 6drop table [dbo].[emps]
 7GO
 8
 9if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[guest]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
10drop table [dbo].[guest]
11GO
12
13CREATE TABLE [dbo].[deps] (
14    [dep_id] [int] NOT NULL ,
15    [name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
16) ON [PRIMARY]
17GO
18
19CREATE TABLE [dbo].[emps] (
20    [emp_id] [int] NOT NULL ,
21    [emp_login] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
22    [emp_password] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
23    [emp_level] [int] NULL ,
24    [name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
25    [emp_No] [int] NULL ,
26    [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
27    [email] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
28    [work_phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
29    [home_phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
30    [cell_phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
31    [address] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
32    [dep_id] [int] NULL ,
33    [picture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
34    [manmonth] [int] NULL 
35) ON [PRIMARY]
36GO
37
38CREATE TABLE [dbo].[guest] (
39    [ID] [int] NOT NULL ,
40    [标题] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
41    [署名] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
42    [正文] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
43    [ip地址] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
44) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
45GO
46
47