Toad World® Forums

SQL preview, how to remove quotes


#1

Is there an option to disable the quotes around field names when in the SQL Preview?
Currently I copy the ddl to another text editor to remove the quotes. I’ve tried looking in the menu but can’t find an option in Modeller 6.3.

i.e
CREATE TABLE “TABLE_1”(
“User” Varchar2(30 ),
“firstname” Varchar2(400 ),

to
CREATE TABLE TABLE_1(
User Varchar2(30 ),
firstname Varchar2(400 ),


#2

Hello Rusty,
SQL Preview has setting from “Generator” in your model. So open model, press F9 to open “DDL Script generation of Oracle 10g” adn go to Detail Settings. There is option “Use Quotation Marks”, deselect it. To save this settings is necessary run one time generate, so click to generate button.
Now in your SQL preview you will have statements without quotations.

Daril