• Yes that is correct, any referencing objects need to be manually updated with the new table name, SQL wont do it for you.

    It even gives you a warning once the rename has happened to detail this could break things.

    Changing any part of an object name can break scripts and stored procedures.