用sql脚本创建sqlserver数据库范例语句

USE [master]
GO
IF EXISTS(SELECT 1 FROM sysdatabases WHERE NAME=NHkTemp)
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(NHksj_User) AND type in (NU))
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=NMS_Description, @value=N登录名 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NHksj_User, @level2type=NCOLUMN,@level2name=NSName
GO
EXEC sys.sp_addextendedproperty @name=NMS_Description, @value=N邮箱 , @level0type=NSCHEMA,@level0name=Ndbo, @level1type=NTABLE,@level1name=NHksj_User, @level2type=NCOLUMN,@level2name=NSEmail