SQL server 自带存储过程 sp_rename
时间:2022-03-15 19:37
使用系统自带存储过程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‘
时间:2022-03-15 19:37
使用系统自带存储过程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‘