常用语句（五）index、clustered、unique、... view ... as ...、... from view

/*
*/
create index cluster on student(sno)
go
drop index student.cluster
go
alter table score drop constraint FK_score1
go
alter table score drop constraint FK_score2
go
alter table student drop constraint PK_student
go
create clustered index addcluster on student(sno)
go
drop index student.addcluster
go
create unique index sname_uq_index on student(sname,age)
go
drop index student.sname_uq_index
go
create view student_view as select * from student
go
select * from student_view
go
drop view student_view
go
create view s_view as select sname,age from student
go
select * from s_view
go
drop view s_view
go
/*
*/
create index course_cluster on course(cno,cname)
go
drop index course.course_cluster
go
create view s_view as select st.sno,sname from score sc inner join student st on st.sno=sc.sno where st.sname like '张%' and sc.cno=(select cno from course where cname like '%英语%') and grade is not null
go
select st.sno,sname from student st inner join score sc on st.sno=sc.sno inner join course co on co.cno=sc.cno where st.sname like '张%' and co.cname like '%英语%' and grade is not null
go
select * from s_view
go
drop view s_view
go
/*
*/