I am using FB 1.0, and using IBExpert as the front-end to manage the
databases.

I tried creating a view in my database, combining two tables in an
SQL SELECT query. When I compiled the view, the result
was 'successful'. I want to know how I can save the view into the
database. Currently the only Save operation that is possible seems
to be to save the view definition in a disk file with the extension
of 'SQL'.

Is this the only way of storing views in a Firebird database? If so,
what happens if I want to deploy the database with the views to a
client's site? Do I need to copy the .SQL files too?

Thanks,

Anand