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

Chat now with support

Zurück

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Titel

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

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

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

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]
Lösung

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.
Fehler-ID

TDM-2452

Feedback übermittelt

Konnten Sie mithilfe dieses Artikels ein Problem lösen?

Bewertung auswählen

Empfohlener Inhalt

Titel