Generate Schema Script does not show column alias names for views. (64499)

Chat now with support

Return

Feedback Submitted

Was this article helpful?

Select Rating

Title

Generate Schema Script does not show column alias names for views.
Description

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;
Resolution

Download the current release of Toad for Oracle at: https://support.quest.com/Search/SearchDownloads.aspx

Feedback Submitted

Was this article helpful?

Select Rating

Title