Reputation: 2760
I'm dealing with a legacy database and I'd like to create a test version of it.
It's based on views as opposed to tables.
I'm wondering if someone here knows a nice quick way to export sql from the views with all the data types which I could then use to create a hsql table based version of the database?
Upvotes: 0
Views: 343
Reputation: 15493
You can use most IDEs (Toad or SQL Developer for example) to view and extract underlying SQL from views (and types from snapshot tables). This would be the easiest and most friendly approach.
The alternative would be to use a built in package DBMS_METADATA
select dbms_metadata.get_ddl('VIEW', 'MY_VIEW') from dual;
See here for other options (like 'MATERIALIZED_VIEW') and examples.
Upvotes: 2