使用系统自带存储过程sp_rename 修改之前创建的视图名字

CREATE VIEW v_ShowBoyInfo as select * from employee WHERE sex =‘男‘ and age>18 and age<35;


EXEC sp_rename ‘v_ShowBoyInfo‘, ‘v_ShowYoungerInfo‘

SQL server 自带存储过程 sp_rename