Steps to reproduce:
- Create table A with identity column GroupId
- Create table B with identity column ItemId and GroupId with FK to A.GroupId with cascade
- Alter table A and add a new column.
The generated script gives an error on its last line
DROP TABLE [Admin].[tmp_8460ef8c7e3c4018b3b1580c83726ff7]
about not being able to drop table because FK references exist because table B actually is referencing the tmp table as its foreign key since near the top of the script the table is renamed in prep for a rebuild:
@objname = N’[dbo].[A]’,
@newname = N’tmp_8460ef8c7e3c4018b3b1580c83726ff7’,
@objtype = ‘OBJECT’;
The script be enhanced to re-reference FKs away from the tmp file and to the new table before the final delete of tmp table at the end of the script.
Thanks for your consideration!
Message was edited by: chris.rokusek_218