创建sqlserver数据库脚本 范例

USE [ master ]
GO

IF EXISTS ( SELECT 1 FROM sysdatabases WHERE NAME = N ' HkTemp ' )
BEGIN
DROP DATABASE HkTemp -- 如果数据库存在先删掉数据库
END
GO

CREATE DATABASE HkTemp
ON
PRIMARY -- 创建主数据库文件
(
NAME = ' HkTemp ' ,
FILENAME = ' E:\Databases\HkTemp.dbf ' ,
SIZE = 5MB,
MaxSize = 20MB,
FileGrowth = 1MB
)
LOG ON -- 创建日志文件
(
NAME = ' HkTempLog ' ,
FileName = ' E:\Databases\HkTemp.ldf ' ,
Size = 2MB,
MaxSize = 20MB,
FileGrowth = 1MB
)
GO
--添加表
IF NOT EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N ' Hksj_User ' ) AND type in (N ' U ' ))
BEGIN
CREATE TABLE Hksj_User
(
Id INT IDENTITY ( 1 , 1 ) NOT NULL ,
SName NVARCHAR ( 20 ) NOT NULL ,
SNickName NVARCHAR ( 20 ),
SPassWord NVARCHAR ( 30 ) NOT NULL ,
DCreateDate DATETIME ,
SCreator NVARCHAR ( 20 ),
SEmail NVARCHAR ( 50 ),
SPhone NVARCHAR ( 50 ),
SIdentifyId NVARCHAR ( 30 ),
DLastTimeLogOn DATETIME

PRIMARY KEY CLUSTERED
(
Id ASC
) WITH (IGNORE_DUP_KEY = OFF ) ON [ PRIMARY ]
) ON [ PRIMARY ]
END
GO
--添加注释
EXEC 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'
GO
EXEC 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'