Subject | Re: Creating a view |
---|---|
Author | akashelkar |
Post date | 2003-07-05T10:09:49Z |
Oops! I didn't want to know how to 'write' a view, but I merely want
to know how a view I have written can be saved in a Firebird database
using IBExpert.
As I said, presently IBExpert only allows me to save the view
definition to a text file with the extension of SQL, while I want to
know how it can be saved inside the database, just like the normal
way.
Thanks,
Anand
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
to know how a view I have written can be saved in a Firebird database
using IBExpert.
As I said, presently IBExpert only allows me to save the view
definition to a text file with the extension of SQL, while I want to
know how it can be saved inside the database, just like the normal
way.
Thanks,
Anand
--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
> 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