Toad World® Forums

Creating Dynamic SQL


#1

/* Formatted on 2009/04/07 10:32 (Formatter Plus v4.8.7) */

Can someone jog my memory as to how to create a stub SQL Script from a Table???

Thanks in advance for your help.

PSULionRP

I am novice to SQL Navigator. Within SQL Navigator, I believe I have used some utility before to automatically create a stub SQL Script for a Table.

The comment at the top of it states…

__


#2

Right click on a table and select extract DDL?


#3

Or right click on the data grid and select Preview changes after you modify the data?


#4

I did not mean the DDL. I meant I did something before that automatically created a stub SQL SELECT Script based on the Table I was interested in.

I hope I’m clear.

Thanks in advance for your review and help.


#5

Right click on a table and select ‘Quick Browse’ or ‘Edit data’? Shortcuts are also available.

Hope this helps
Gwen


#6

Perhaps, you just dragged a table name from DB Explorer into Editor? There’s a preference that controls what’s inserted in this situation: table name, SELECT * FROM , or SELECT FROM .

Hope this helps,
Roman