Return
-
Title
Script for View does not contain the original 'Select * from...'. Is there an option to allow this? -
Description
Table MyTable with columns called A and B. A view is created based on selecting all columns from MyTable i.e.
SQL CREATE VIEW MyView as Select * from MyTable
When to the script tab in Schema Browser for the view it displays as:
CREATE OR REPLACE VIEW MyView as SELECT "A","B" from mytable.
Why is the * being replaced with the "A,"B" column names?
Is there an option to have it display as it was originally created?
-
Resolution
Toad runs a series of sql statements to gather metadata from Oracle Views in order to build the script. There is no option to have it scripted out with the 'select * from...'. Note that within the Oracle metatdata views, the sql statement is also stored with all the columns referenced. This can be confirmed by running:select dbms_metadata.get_ddl('VIEW', 'view name', 'owner') from dual;