ASP教务管理系统案例

if exists (select 1 from sysobjects where id = object_id('course') and type = 'U') drop table course go /*==============================================================*/ /* Table: 諺最 */ /*==============================================================*/ create table course ( Course_id varchar(50) not null, Course_name varchar(50) not null, Course_period int not null, Course_credit int not null, Course_kind int not null, Course_describe varchar(50) not null, constraint PK_course primary key (Course_id) ) go