1、建表
create table Student
(Sno char (9) primary key,
Sname char (20) unique,
Ssex char(2),
Sage smallint,
Sdept char(20),
);
create table Course
(Cno char(4) primary key,
Cname char (40),
Cpno char(4),
Ccredit SMALLINT,
foreign key (Cpno) references Course(Cno),
)
create table SC
(Sno char (9),
Cno Char (4),Grade smallint,
primary key (Sno,Cno),
foreign key (Sno) references Student (Sno),
foreign key (Cno) references Course (Cno),
)
2、插入
insert into student (sno,sname,ssex,sdept,sage) values ('200215128','陈东','男','IS',18)
3、删除
dorp table student,student2
4、更改
更改表名 exec sp_rename 'student','Student2';
增加一列 alter table Student add S_entrance datetime;
更改列的数据类型 alter table student alter column sage int;
增加约束条件 alter table Course add unique (Cname);
create table Student
(Sno char (9) primary key,
Sname char (20) unique,
Ssex char(2),
Sage smallint,
Sdept char(20),
);
create table Course
(Cno char(4) primary key,
Cname char (40),
Cpno char(4),
Ccredit SMALLINT,
foreign key (Cpno) references Course(Cno),
)
create table SC
(Sno char (9),
Cno Char (4),Grade smallint,
primary key (Sno,Cno),
foreign key (Sno) references Student (Sno),
foreign key (Cno) references Course (Cno),
)
2、插入
insert into student (sno,sname,ssex,sdept,sage) values ('200215128','陈东','男','IS',18)
3、删除
dorp table student,student2
4、更改
更改表名 exec sp_rename 'student','Student2';
增加一列 alter table Student add S_entrance datetime;
更改列的数据类型 alter table student alter column sage int;
增加约束条件 alter table Course add unique (Cname);