部分实例代码（注意使用关系数据库标准语言SQL 实现代码） create database student
use student
create table student
(
sno char(10) primary key,
sname char(10),
sageint,
ssex char(2)check(ssex in ('男',' 女')),
sdept char(2)
)
create table course
(cno char(10),
cname char(20),
ccreditsmallint
primary key(cno),
teacher char(10)
)
create table sc
(sno char(10) references student(sno),
cno char(10),
gradeint,
primary key(cno,sno),
foreign key(cno) references course(cno)
)
insert
into student
values
(95001,'李勇',' 男',20,'CS',1996);
insert into student values
(95002,'刘晨',' 女',20,'IS',1996);
insert into student values
(95003,'王名',' 女',18,'MA',1996);
insert into student values
(95004,'张立',' 男',19,'IS',1996);
alter table course
drop column teacher
insert into course values (1,'数据库',4);
insert into course values (2,'数学',2);
insert into course values (3,'信息系统',4);
insert into sc values (95001,1);
insert into sc values (95001,2);
insert into sc values (95001,3);
insert into sc values (95002,2);
insert into sc values (95002,3);
select *
from student;
select *
from course;
select *
fromsc;
selectstudent.sno,sname,ssex,cno
fromstudent,sc
wherestudent.sno=sc.sno;
create unique index sc grade on sc(grade desc,snoasc); drop index sc.scgrade;
alter table student
alter column sage smallint;
create database spj
usespj
create table s
(
sno char(10) primary key,
sname char(10),
city char(10)
)
create table p
(
pno char(10) primary key,
pname char(10),
color char(3) check(color in('红',' 绿',' 蓝')), weight char(10)
)
create table j
(
jno char(10) primary key,
jname char(10),
city char (10)
)
create table spj
(
sno char(10) references s(sno), pno char(10),
jno char(10),
qtyint,
primary key (sno,pno,jno),
foreign key (pno) references p(pno), foreign key (jno) references j(jno) )
alter table spj add orderdatedatetime;
create table s1
(
sno char(10),
sname char(10),
city char(10)
)
create clustered index s1sno on s1(sno);
insert intoselect *
fromspj;
selectsno,sname
from student
wheresno=95001;
部分实例代码（注意使用关系数据库标准语言SQL 实现代码） create database student
use student
create table student
(
sno char(10) primary key,
sname char(10),
sageint,
ssex char(2)check(ssex in ('男',' 女')),
sdept char(2)
)
create table course
(cno char(10),
cname char(20),
ccreditsmallint
primary key(cno),
teacher char(10)
)
create table sc
(sno char(10) references student(sno),
cno char(10),
gradeint,
primary key(cno,sno),
foreign key(cno) references course(cno)
)
insert
into student
values
(95001,'李勇',' 男',20,'CS',1996);
insert into student values
(95002,'刘晨',' 女',20,'IS',1996);
insert into student values
(95003,'王名',' 女',18,'MA',1996);
insert into student values
(95004,'张立',' 男',19,'IS',1996);
alter table course
drop column teacher
insert into course values (1,'数据库',4);
insert into course values (2,'数学',2);
insert into course values (3,'信息系统',4);
insert into sc values (95001,1);
insert into sc values (95001,2);
insert into sc values (95001,3);
insert into sc values (95002,2);
insert into sc values (95002,3);
select *
from student;
select *
from course;
select *
fromsc;
selectstudent.sno,sname,ssex,cno
fromstudent,sc
wherestudent.sno=sc.sno;
create unique index sc grade on sc(grade desc,snoasc); drop index sc.scgrade;
alter table student
alter column sage smallint;
create database spj
usespj
create table s
(
sno char(10) primary key,
sname char(10),
city char(10)
)
create table p
(
pno char(10) primary key,
pname char(10),
color char(3) check(color in('红',' 绿',' 蓝')), weight char(10)
)
create table j
(
jno char(10) primary key,
jname char(10),
city char (10)
)
create table spj
(
sno char(10) references s(sno), pno char(10),
jno char(10),
qtyint,
primary key (sno,pno,jno),
foreign key (pno) references p(pno), foreign key (jno) references j(jno) )
alter table spj add orderdatedatetime;
create table s1
(
sno char(10),
sname char(10),
city char(10)
)
create clustered index s1sno on s1(sno);
insert intoselect *
fromspj;
selectsno,sname
from student
wheresno=95001;