Getting "No parent item (key or index) has been found during foreign key creation" error reverse engineering script (4244648)

Getting "No parent item (key or index) has been found during foreign key creation" error reverse engineering script

When reverse engineering from a script, the following error is returned.

"No parent item (key or index) has been found during foreign key creation"

Toad Data Modeler cannot currently handle the ALTER TABLE statements that add a new attribute to the table and create a primary key at the same time, for example:

ALTER TABLE [dbo].[t_User] ADD [CDC_Login] [varchar](10) NULL CONSTRAINT [PK_t_User_Information] PRIMARY KEY CLUSTERED 
(
  [UserID] ASC
)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]

WORKAROUND #1:
Divide these ALTER TABLE statements into two separate statements.  The first adds a new column and the second creates a primary key. 

WORKAROUND #2:
Execute the original DDL script in the database and then reverse engineer the created result.

STATUS:
This issue is fixed in Toad Data Modeler 6.1. This version can be downloaded from the downloads section of our website, which you can access by clicking here.

TDM-2452