Return
-
Title
Generate a script for renaming a table with references objects -
Description
User tried to rename a table which had many referential constraints, Toad gave him error SQL0750N:
SQL0750N The source table cannot be renamed because it is referenced in a view, materialized query table, trigger, SQL function, SQL method, check constraint, referential constraint, or XSR object. SQLSTATE=42986So customer requested that Toad would generate all steps in order to rename.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.