Subject Re: [firebird-support] SQL statements from all views
Author Norman Dunbar
Afternoon,

> I would like to made some migration tool and I need to get SQL statement of all views from my FirebirdSQL database. Is this possible and how to get this scripts?
How about running isql to extract the metadata for the whole database:

isql -x <database> -user xxx -password yyyyy

You can redirect the output to a file as follows:

isql -x <database> -user xxx -password yyyyy > listing.sql

All on one line if it has wrapped in transit.


HTH

Cheers,
Norman.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767