![]() ![]() So it’s not recommended to use this sp_rename statement to rename stored procedures, triggers, user-defined functions, or views you should drop the object and re-create it with the new name instead. However, as you execute the statement changing the name for a column, you will probably receive a warning that changing any part of an object name can break scripts and stored procedures. EXEC sp_rename 'schema_name.old_table_name', 'new_table_name' ![]()
0 Comments
Leave a Reply. |