Using Toad 10.1, Generate Schema Script is used to generate scripts for views. The generated CREATE OR REPLACE VIEW statements do not show the column alias names inside parenthesis as such:
CREATE OR REPLACE FORCE VIEW VIEWTEST
(COL1, COL2, COL3, ...) <--This line is not included in script
AS
select "COL1","COL2","COL3",... From abc;
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