createtable.sql

来自「这是别人的数据库课程设计」· SQL 代码 · 共 40 行

Use MyDB
Create Table Login
(Name varchar(10) not null Primary key,
Password varchar(10) not null
)
go
Create Index idxLogin on Login(Name)
Insert Into Login Values('manager','1234567')
GO
/*创建专业表*/
Create Table Speciality
(Name varchar(30) Not Null Primary key)
go 
/*创建民族表*/
Create Table Nation
(Name varchar(20) Not Null Primary key)
go  
GO
/*创建学生表*/
Create Table Student
(ID Varchar(20) Not Null,   /*学号*/
Name varchar(12) Not Null,/*姓名*/
Sex varchar(2),                       /*性别*/
Birthday DateTime ,              /*出生年月*/
Nation varchar(20),              /*民族*/
Speciality varchar(40),    /*专业*/
Phone varchar(30),          /*电话*/
StatusID varchar(30) ,        /*身份证号*/
Email varchar(50),              /*电子信箱*/
HouseName varchar(12),      /*家长姓名*/
HousePhone varchar(30),     /*家长电话*/
HouseAddress varchar(50),  /*家庭地址*/
PostCode varchar(6),         /*邮政编码*/
Memo text ,                          /*备注*/
Primary Key(ID)                  /*主键约束*/
)
Go
Create Index idxStudent on Student(ID)
Go