Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Small enhancement to EDB Manager
Tue, Aug 2 2016 5:06 AMPermanent Link

Adam Brett

Orixa Systems

EDB Manager has a great feature: dragging a "Table" icon from the tree-view into a SQL window generates CREATE SQL.

You are also given the option to SQL to INSERT data.

It would be great if you were also given options to generate SQL to Create Triggers & Indexes, as if you are re-creating a table, these are constituent elements of the table, and you will want to add these as well.

Adam
Tue, Aug 2 2016 5:08 AMPermanent Link

Adam Brett

Orixa Systems

I realise that you can also drag the triggers into the window to create them, I am just talking about automating the process to speed it up and avoid accidental omissions.
Tue, Aug 2 2016 5:30 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Adam


Unfortunately, I have to say that's a bad idea. I have triggers that rely on / carry out actions on other tables, or require external functions. That could give far more grief than having to drag them over later on.

Roy Lambert
Wed, Aug 3 2016 7:04 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Adam,

<< It would be great if you were also given options to generate SQL to Create Triggers & Indexes, as if you are re-creating a table, these are constituent elements of the table, and you will want to add these as well. >>

Thanks, I'll see what I can do.

Tim Young
Elevate Software
www.elevatesoft.com
Image