Toad World® Forums

Interesting Feature Request


#1

I was doing some optimization work on our database this morning which involves
making some views as tables. It would be an awesome feature if I could right
click on a view and have an option to create table like view that would
interrogate the view and make the creation script of a table with the same
column names and definition as in the view. I find myself doing it some
recently for data warehousing and optimization reasons and it would be a killer
feature to have.


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com


#2

I like it. I’ll create enhancement request to implement this feature in
the next release.

Thanks,

Igor.


#3

It’s probably a bit much to ask but it would also be nice if maybe once that
feature is done if you could tick something to create a stored procedure that
would populate the table that has the same SQL that was in the view. That is
probably a lot harder to do but would be nice to have as well.

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com

On Wed, May 26, 2010 at 12:31 PM, Igor Manokhin
wrote:

I like it. I’ll create enhancement request to implement this feature in
the next release.

 

Thanks,

 

Igor.

#4

Do you mean you need to populate the newly created table at some time later or
it’s enough to create a table and populate it at the same time?

Igor.


#5

I’d be populating it at some point in time in the future. What I’m
ending up doing is creating a table that is exactly like the view and populating
it with data when the view would normally be populated only I’m populating
it in my .NET code using the new stored procedure. So the stored procedure
that you would create would probably have to take the were query from the view
and add those as parameters to the stored procedure I’m guessing or
something like that.


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recorded books.com

On Wed, May 26, 2010 at 3:05 PM, Igor Manokhin
wrote:

Do you mean you need to populate the newly created table at some time later
or it’s enough to create a table and populate it at the same time?

 

Igor.

#6

I second this request! (Actually I asked for it last year… from a query or a
view)

You write a long complicated query drawing data from 20-30 tables. Then you
decide to make a datamart out of it… and then you have to hand-assemble the
CREATE code IF you haven’t clued to a SELECT TOP 0 * INTO (table) approach.

It would be nice (and presumably simple to code) to have an option off of the
query results pane.

On 5/26/2010 at 10:03 AM, wrote:
It’s probably a bit much to ask but it would also be nice if maybe once that
feature is done if you could tick something to create a stored procedure
that would populate the table that has the same SQL that was in the view.
That is probably a lot harder to do but would be nice to have as well.

Thanks,


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recordedbooks.com

On Wed, May 26, 2010 at 12:31 PM, Igor Manokhin
wrote:

I like it. Ill create enhancement request to implement this feature in
the next release.

Thanks,

Igor.

From: toad_ss_beta@yahoogroups.com [mailto: toad_ss_beta@yahoogroups.com ]
*On Behalf Of *Charles Haines
Sent: Wednesday, May 26, 2010 7:24 AM
To: toad_ss_beta
Subject: [toad_ss_beta] Interesting Feature Request

I was doing some optimization work on our database this morning which
involves making some views as tables. It would be an awesome feature if I
could right click on a view and have an option to create table like view
that would interrogate the view and make the creation script of a table with
the same column names and definition as in the view. I find myself doing it
some recently for data warehousing and optimization reasons and it would be
a killer feature to have.


Charles Haines
Senior Software Developer
P: (410) 535-5590 x1196

Recorded Books, LLC
http://www.recordedbooks.com


#7

I’ve already created enhancement request to address this. Some bad news
though. First, we’re in feature freeze for 5.0 release. It means it cannot
be implemented in 5.0. Second, I’m not sure about “postponed”
population of this based-on-the- view table. We don’t create any database
objects in support of Toad functionality (should I explain why? J ). But it
doesn’t seem too bad to me because we can have an option to populate this
table right after its creation. What do you think?

Igor.