DBstar+SQL 源代码

alter table person drop fk_deptno alter table person add constraint fk_deptno foreign key(deptno) refer…

sp_grantlogin 'workgroup\guest05'

delete pay where no='000006'

create view dbo.view_person(no,name,sex,professor,deptno) as select no,name,sex,professor,deptno from dbo.pe…

select* from person where no in(select no from pay where year=2005 and month=1 and …

alter table dept add constraint pri_deptno primary key(deptno)

alter table pay add constraint fk_no foreign key(no) references person(no)

sp_unbindrule'person.professor' drop rule rule_prof

drop index pay.sort_fact

create