---创建视图
create view v_student
as
select stu.Sname
from dbo.T_student stu
--只查看学生表的姓名
select *
from v_student
--修改视图
alter view v_student
as
select stu.Ssex
from dbo.T_student stu
--只查看学生表的性别
select *
from v_student
--查看视图定义的信息
exec sp_help v_student
--多表联查r
create view v_teacher
as
select tea.Tname,
cou.Cname
from dbo.T_teacher tea
inner join dbo.T_course cou
on tea.T#=cou.T#
--查看
select *
from v_teacher
--查看所有数据库
exec sp_help databases;
--查询所有表
exec sp_tables;
---查看指定表的索引
exec sp_helpIndex T_course;
--重命名索引
exec sp_rename N'student.idx_cid',N'idx_cidd', N'index';
---自定义存储过程
create proc proc_get_student
as
begin
select * from dbo.T_student;
end
go
exec proc_get_student