Not sure if this has been brought up before or not but when I create
views with ElevateDB Manager, I can't go back and check the SQL I wrote.
 Being quite stupid sometimes, okay most times, I forget what SQL I
wrote to create the view.  Is there a way to see the SQL of a view from
with ElevateDB Manager?

Thanks.

Regards,

SteveG

Steve,
you can use:

select * from information.views

Regards, Harry

"Steve Gill" <v8steve_removethis_@gmail.com> schreef in bericht
news:DD9DDAF6-CD1A-4D50-AC6C-BC18255889E6@news.elevatesoft.com...
> Not sure if this has been brought up before or not but when I create
> views with ElevateDB Manager, I can't go back and check the SQL I wrote.
>   Being quite stupid sometimes, okay most times, I forget what SQL I
> wrote to create the view.  Is there a way to see the SQL of a view from
> with ElevateDB Manager?
>
> Thanks.
>
> Regards,
>
> SteveG

> you can use:
>
> select * from information.views

Excellent.  Thanks Harry.

Regards,

SteveG

Steve,

<< Not sure if this has been brought up before or not but when I create
views with ElevateDB Manager, I can't go back and check the SQL I wrote.
Being quite stupid sometimes, okay most times, I forget what SQL I wrote to
create the view.  Is there a way to see the SQL of a view from with
ElevateDB Manager? >>

This will be available soon, but for now use the method already mentioned -
SELECT * FROM Information.Views.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> This will be available soon, but for now use the method already mentioned -
> SELECT * FROM Information.Views.

Great, thanks Tim.

SteveG