今天学习SqlServer2005 sql语句,在网上找了不少,但是在测试的时候,发现了不少问题。我把有问题的进行重新测试,改过来。修改结果如下:
use test
go
alter table Teachers add address varchar(100)
go
alter table Teachers alter column address varchar(20)
go
delete from teachers
go
--增加主键
alter table Teachers add constraint PK_TeacherID primary key(teacherID)
go
--删除主键
alter table Teachers drop constraint PK_TeacherID
go
--创建索引
create index Index_TeacherName on Teachers(teacherName)
go
--删除索引
drop index Index_TeacherName on Teachers
go
--创建视图
create view V_Select_All_Teachers as select * from Teachers
go
--删除视图
drop view V_Select_All_Teachers
go