teacher_course.sql

来自「C# SQL遍写的学生选课系统 给大家看看 有点多 有点复杂」· SQL 代码 · 共 18 行

if exists (select 1
            from  sysobjects
           where  id = object_id('teacher_course')
            and   type = 'U')
   drop table teacher_course
go
/*==============================================================*/
/* Table: 教课                                                    */
/*==============================================================*/
create table teacher_course (
Record_id            int                  not null,
Teacher_id           varchar(50)          null,
Course_id            varchar(50)          null,
Course_year           char(5)              null,
constraint PK_teacher_course primary key  (Record_id)
)
go