Executing data script generated by Toad, get a message saying constraint "references invalid table" (4246815)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Executing data script generated by Toad, get a message saying constraint "references invalid table"
Description

When executing a script generated by using Generate SQL | Data Script, an error is received that says the constraint "references invalid table".
Cause

Tables are created in alphabetical order with no regard for any constraints.
Resolution

WORKAROUND:
Run the script out of order, so that the portions of script that reference other tables being created by the script are executed after the tables that they reference.

STATUS:
Waiting for fix to be released in a future version of Toad for SQL Server.
Defect ID

TSS-135

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title