When renaming and dropping table columns that are associated with triggers using Alter Table window, Toad generates an incorrect script. Script contains a single ALTER TABLE command which cannot be executed for columns associated with triggers. A DROP/CREATE TABLE needs to be generated in order successfully change these columns.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center