文件名称:学生成绩管理系统源代码
文件大小:13KB
文件格式:SQL
更新时间:2012-07-12 08:37:37
成绩管理
学生成绩管理系统源代码if exists(select 1 from sys.sysforeignkey where role='FK_CHOOSE_C_CHOOSE_CO_COURSES') then alter table choose_course delete foreign key FK_CHOOSE_C_CHOOSE_CO_COURSES end if; if exists(select 1 from sys.sysforeignkey where role='FK_CHOOSE_C_CHOOSE_CO_STUDENT') then alter table choose_course delete foreign key FK_CHOOSE_C_CHOOSE_CO_STUDENT end if; if exists(select 1 from sys.sysforeignkey where role='FK_STUDENT_HAVE_STUD_SCHOOL') then alter table student delete foreign key FK_STUDENT_HAVE_STUD_SCHOOL end if; if exists(select 1 from sys.sysforeignkey where role='FK_TEACH_TE_TEACH_TEA_COURSES') then alter table teach_teachers delete foreign key FK_TEACH_TE_TEACH_TEA_COURSES end if;