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

Tchater maintenant avec le support

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

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

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

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

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]
Résolution

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.
Identifiant du défaut

TDM-2452

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 8/2/2016
Dernière mise à jour le : 5/7/2023

Titre