sql server表操作T-sql

create table StudentInfo
( Stu_id varchar(10) primary key,
  Stu_Name varchar(20) not null,
  Stu_Sex varchar(2) default('男') check( Stu_sex in('女','男')),
  Brith_date datetime check(Brith_date< getdate()) ,
  Jion_date datetime default(getdate()),
  PaperCode  varchar(20) unique)

create table Grades
( Stu_id varchar(10)foreign key references StudentInfo(Stu_id) not null,
  Class_id varchar(10) primary key(stu_id,Class_id),
  Grade numeric default(0) check(grade>=0 and grade<=100)
)
 
create table ClassInfo
( Class_id varchar,
   Class_Desc varchar(50)
)
-----------------------------------------------
----修改表结构
     ---修改表中列的数据类型
 alter table ClassInfo
    alter column Class_desc varchar(20)

alter table ClassInfo
    alter column Class_id varchar(10) not null
   ---添加列
 alter table ClassInfo
    add ClassQty int
   ---删除列
 alter table ClassInfo
     drop column ClassQty
-------------------------------------------------
---修改表约束
  
   ---加主键
 alter  table ClassInfo
        add constraint pk_Id primary key (Class_id)
 ---加默认值
 alter table ClassInfo
      add constraint Df_Qty default(0) for ClassQty
---加外键
 alter table Grades
       add constraint Fk_class_id foreign key(Class_id) references classInfo(class_id)

--加check约束
  alter table studentInfo
    add constraint CK_date Check(Jion_date> Brith_date)

---删除约束
  alter table StudentInfo
    drop Constraint CK_date