Re: [Tora-develop] possible feature idea if feasible

[Mike J. <mrj...@mi...>]

Wouldn't it be better/easier to use:

create table mytable as (select * from myview);

Is that what you're trying to do?

On Fri, Jun 12, 2009 at 2:08 PM, Neulinger, Nathan<nn...@ms...> wrote:
> I was helping someone today with duplicating a view as a table. One nice
> thing with Tora is that you can see all the underlying data types
> presented by the view, which is what was needed. (With the tool they
> were using, they were having to track down all the individual component
> views to get the data types.)
>
> However, what would have been even better, is if there were a secondary
> SQL tab on views in the schema browser, that would show the sql to
> create an table with the same structure as the view.
>
> i.e. where the current sql says "create view x as ..... ", have a
> "TableSQL" tab that would phrase it as a table instead of a view:
>
> "create table x (
>  ...
>  );"
>
> using the same column names and data types/not null/etc. as show on the
> 'Columns' tab of the schema browser.
>
> -- Nathan
>
> ------------------------------------------------------------
> Nathan Neulinger                       nn...@ms...
> Missouri S&T Information Technology    (573) 341-6679
> System Administrator - Principal       KD0DMH
>
>
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Tora-develop mailing list
> Tor...@li...
> https://lists.sourceforge.net/lists/listinfo/tora-develop
>
>