IT日志之SqlServer数据库：创建库/表

--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






)

create database School






use  School


create table TblClass


(


tClassId int identity(1,1) primary key,


tClassName nvarchar(50) not null,


tClassDesc varchar(100) null


)






create table TblStudent


(


tSId int identity(1,1) primary key,


tSName nvarchar(50) not null,


tSGender nchar(1), 


tSAddress varchar(100) ,


tSPhone varchar(20),


tSAge int ,


tSBirthday datetime ,


tSCardId varchar(18),


tClassId int






)


create table TblScore


(


tScoreId int identity(1,1) primary key,


tSId int not null,


tEnglish float,


tMath float






)


create table TblTeacher


(


tTId int identity(1,1) primary key,


tTName nvarchar(50) not null,


tTGender nchar(1),


tTSalary money,


tTAge int,


tTBirthday datetime


)