How to hide Caution: Changing any part of an object name could break scripts and stored procedures

Question

In my database I am renaming a table. I tried to rename it by using

exec sp_rename Student,Students

but I got the message:

Caution: Changing any part of an object name could break scripts and stored procedures.

How can I avoid getting this message?

Answer 1

Unfortunately, this message cannot be suppressed.*

There was a Microsoft Connect ticket submitted by our very own Aaron Bertrand, but it was closed as won't fix.

Keep in mind that this message isn't an error - it's not even a warning - it's just a cautionary message saying, "Be careful."

---

^{*Okay, it can be suppressed, but it involves modifying the source code of sp_rename, which is not recommended.}