sql-serverforeign-keystable-rename

sql:need to change constraint on rename table?

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

Solution

  • 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.