基本Sql语句：SqlServer2005

时间：2011-03-08 来源：天璇翼

今天学习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

相关阅读更多 +