use StudentDB
go
createschema my
go
--创建数据表createtable my.Tb_Stu_Info
(
Stu_No varchar(12)primarykeynotnull,
Stu_Name nvarchar(10),
Stu_Sex nvarchar(6),
Stu_Birthday date,
Stu_Address nvarchar(200))
go
2. 添加列
① 添加单列
--添加一个名为stest的列altertable my.Tb_Stu_Info
add stest intnotnull
go
② 添加多列
--添加Stu_Birthday,Stu_Address列altertable my.Tb_Stu_Info
add Stu_Birthday date,
Stu_Address nvarchar(200)
go
3. 修改列
--修改stest的数据类型altertable my.Tb_Stu_Info
altercolumn stest varchar(10)
go
4. 删除列
① 删除单列
--删除 stest 列altertable my.Tb_Stu_Info
dropcolumn stest
go
② 删除多列
--删除Stu_Birthday,Stu_Address列altertable my.Tb_Stu_Info
dropcolumn Stu_Birthday,Stu_Address
go