Sql Server SQL语句创建数据库

             1
            USE
            [
            master
            ]
             2
            GO
             3
            IF
            EXISTS(SELECT1FROM sysdatabases WHERE NAME=N‘HkTemp‘)
 4BEGIN 5DROPDATABASE HkTemp --如果数据库存在先删掉数据库 6END 7GO 8CREATEDATABASE HkTemp
 9ON10PRIMARY--创建主数据库文件11(
12 NAME=‘HkTemp‘,
13 FILENAME=‘E:DatabasesHkTemp.dbf‘,
14 SIZE=5MB,
15 MaxSize=20MB,
16 FileGrowth=1MB
17)
18LOGON--创建日志文件19(
20 NAME=‘HkTempLog‘,
21 FileName=‘E:DatabasesHkTemp.ldf‘,
22 Size=2MB,
23 MaxSize=20MB,
24 FileGrowth=1MB
25)
26GO27--添加表28IFNOTEXISTS (SELECT*FROM sys.objects WHEREobject_id=OBJECT_ID(N‘Hksj_User‘) AND type in (N‘U‘))
29BEGIN30CREATETABLE Hksj_User
31(
32 Id INTIDENTITY(1,1) NOTNULL,
33 SName NVARCHAR(20) NOTNULL,
34 SNickName NVARCHAR(20),
35 SPassWord NVARCHAR(30) NOTNULL,
36 DCreateDate DATETIME ,
37 SCreator NVARCHAR(20),
38 SEmail NVARCHAR(50),
39 SPhone NVARCHAR(50),
40 SIdentifyId NVARCHAR(30),
41 DLastTimeLogOn DATETIME42PRIMARYKEYCLUSTERED43(
44 Id ASC45 )WITH (IGNORE_DUP_KEY =OFF) ON[PRIMARY]46 ) ON[PRIMARY]47END48GO49--添加注释50EXEC sys.sp_addextendedproperty @name=N‘MS_Description‘, @value=N‘登录名‘ , @level0type=N‘SCHEMA‘,@level0name=N‘dbo‘, @level1type=N‘TABLE‘,@level1name=N‘Hksj_User‘, @level2type=N‘COLUMN‘,@level2name=N‘SName‘51GO52EXEC sys.sp_addextendedproperty @name=N‘MS_Description‘, @value=N‘邮箱‘ , @level0type=N‘SCHEMA‘,@level0name=N‘dbo‘, @level1type=N‘TABLE‘,@level1name=N‘Hksj_User‘, @level2type=N‘COLUMN‘,@level2name=N‘SEmail‘