Home
General - Do you know to not use "sp_rename" to rename objects?
  v2.0 Posted at 31/12/2019 12:26 PM by Christian Morford-Waite

​Do not use "sp_rename" to rename objects like stored procedures, views and triggers.​

​​​Object name should be the same as the name used in the object's script (e.g. CREATE script for stored procedures, views and triggers). Inconsistency can happen when object is renamed with sp_rename, but its script is not updated.

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address:

    Comments: