sql:need to change constraint on rename table?

Question

i have change name of table through procedure sp_rename.Do i need to change fk constraint of child table?

Answer 1

Constraints and indexes will be automatically renamed, but you will need to manually do rename work in stored procedures, triggers, user-defined functions, and views that reference the table. See the documentation on MSDN.