t_class.sql

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

if exists (select 1
            from  sysobjects
           where  id = object_id('class')
            and   type = 'U')
   drop table class
go
/*==============================================================*/
/* Table: 班级                                                    */
/*==============================================================*/
create table class (
Class_id             varchar(50)          not null,
Class_name           varchar(50)          not null,
Class_department     varchar(50)          not null,
Class_college        varchar(50)          not null,
Class_teacherid      varchar(50)          not null,
constraint PK_class primary key  (Class_id)
)
go