Hi,

CREATE VIEW (columns)
AS

SELECT ... FROM ... Etc...


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> 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?