【正文】 ) not null, 學生編號 Depar_Id numeric(10) null, 系部編號 class_id numeric(10) null, 班級編號 St_Sex varchar(10) not null, 學生性別 St_Address varchar(50) not null, 學生住址 St_Tel numeric(20) not null, 學生電話 St_Bir datetime not null, 學生生日 constraint PK_STUDENTMANAGE primary key nonclustered (St_Id) 建立主鍵：學生 20 編號 ) Go 數(shù)據(jù)插入 學生管理插入的相關信息： insert into values(39。 and indid 0 and indid 255) drop index 教材發(fā)放 .教材發(fā)放 _FK 18 go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index 教材發(fā)放 .教材發(fā)放 2_FK go if exists (select 1 from sysindexes where id = object_id(39。) drop table 教材使用 go if exists (select 1 from sysindexes where id = object_id(39。 and indid 0 and indid 255) drop index 教材使用 .教材使用 _FK go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index 教材使用 .教材使用 2_FK go if exists (select 1 from sysindexes where id = object_id(39。) 17 drop table studentmanage go if exists (select 1 from sysindexes where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。) drop table TeacherManage go if exists (select 1 from sysindexes where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) drop table TeachManage go if exists (select 1 from sysindexes where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 16 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysindexes where id = object_id(39。) drop table SBMANAGE go if exists (select 1 from sysindexes where id = object_id(39。) drop table GradeManagement go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index 15 go if exists (select 1 from sysindexes where id = object_id(39。) drop table Departmentform go if exists (select 1 from sysindexes where id = object_id(39。) drop table Courseinformationform go if exists (select 1 from sysobjects where id = object_id(39。) drop table Classmangement go if exists (select 1 from sysobjects where id = object_id(39。 and indid 0 and indid 255) drop index go if exists (select 1 from sysobjects where id = object_id(39。) alter table 教材發(fā)放 drop constraint FK_教材發(fā)放 _教材發(fā)放 2_SBMANAGE go if exists (select 1 from sysindexes where id = object_id(39。) where = object_id(39。) and = 39。) alter table 教材使用 drop constraint FK_教材使用 _教材使用 2_SBMANAGE go if exists (select 1 from r join o on ( = and = 39。) where = object_id(39。) and = 39。) alter table studentmanage drop constraint FK_STUDENTM_RELATIONS_CLASSMAN go if exists (select 1 from r join o on ( = and = 39。) where = object_id(39。) and = 39。) alter table TeacherManage drop constraint FK_TEACHERM_RELATIONS_COURSEIN go if exists (select 1 from r join o on ( = and = 39。) where = object_id(39。) and = 39。) alter table TeachManage drop constraint FK_TEACHMAN_RELATIONS_COURSEIN go if exists (select 1 from r join o on ( = and = 39。) where = object_id(39。) and = 39。) alter table GradeManagement drop constraint FK_GRADEMAN_RELATIONS_STUDENTM go if exists (select 1 from r join o on