student_course.sql

来自「基于C#语言的一个教务网数据库系统开发案例的源代码 ,很实用哦」· SQL 代码 · 共 20 行

if exists (select 1
            from  sysobjects
           where  id = object_id('student_course')
            and   type = 'U')
   drop table student_course
go

/*==============================================================*/
/* Table: 选课                                                    */
/*==============================================================*/
create table student_course (
ID                   bigint               not null,
Course_id            varchar(50)          null,
Student_id           varchar(50)          null,
Student_grade        int(4)               null,
Course_year          char(5)              null,
constraint PK_student_course primary key  (ID)
)
go