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

Chatta subito con l'assistenza

Restituisci

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Titolo

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

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

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

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]
Risoluzione

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

TDM-2452

Feedback inviato

Questo articolo ti è servito per risolvere il problema?

Seleziona valutazione

Contenuti consigliati

Cronologia articoli:: Data di creazione: 8/2/2016
Ultimo aggiornamento: 5/7/2023

Titolo