t_student.sql

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

if exists (select 1
            from  sysobjects
           where  id = object_id('student')
            and   type = 'U')
   drop table student
go
create table student (
Student_id           varchar(50)          not null,
Student_name         varchar(50)          not null,
Student_sex          char(5)              not null,
Student_nation       char(5)              not null,
Student_birthday     datetime             not null,
Sturdent_time        datetime             not null,
Student_classid      varchar(50)          not null,
Student_home         varchar(50)          null,
Student_else         varchar(50)          null,
constraint PK_student primary key  (Student_id)
)
go