i have company id is pk in my database and it referd as FK in more than 200 table. So i need to change cascade update rule for FK in all my tables.
ALTER TABLE employeeAddress WITH CHECK ADD CONSTRAINT [FK_companyid] FOREIGN KEY([companyid])
REFERENCES [dbo].[company] ([companyid])
ON UPDATE CASCADE
How do i SEARCH and replace the casecase rule for the column in my db using sql query ?