ä¸é¢æ¯å建ä¸ä¸ª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'
温馨提示:答案为网友推荐,仅供参考