–1.创建数据库
create database MyDatabase
on primary
(
–配置主数据文件的选项
name=’MyDatabase’, –主数据文件的逻辑名称
filename=’c:\MyDatabase.mdf’, –主数据文件的实际保存路径
size=5Mb,
maxsize=150mb,
filegrowth=20%
)
log on
(
–配置日志文件的选项
name=’MyDatabase_log’,
filename=’c:\MyDatabase_log.ldf’, –日志文件的实际保存路径
size=5Mb,
filegrowth=5mb
)
—在数据库中创建表
use MyDatabase
create table Employees
(
EmpID int identity(1,1) primary key,
EmpIDCard varchar(18) not null,
EmpName nvarchar(50) null,
EmpGender bit not null,
EmpJoinDate datetime,
EmpAge int,
EmpAdress nvarchar(100),
DeptID int not null,
EmpEmail varchar(100)
)
create table Department
(
DepID int identity(1,1) primary key,
DepName nvarchar(50) null
)
