(Kenneth Fisher) For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically when you use sp_rename it changes the name of an object in the catalog tables.
Read More - Register for Free Membership