Toad World® Forums

Include schema with script generated SQL


#1

Todo: Add the schema (or make it optional) to generated script objects

Why: I wanted to make a Postgres index unique, so I browsed to the indexes and double-clicked on it. That put me back on the table. OK... So I guess you can't just modify it directly.

So I then clicked on edge to give me a script for the table with all the indexes. It did, but with no schema identifier - so I had to add that to the SQL before you can execute it. Not a big deal for a couple objects, but if I had a whole bunch it would be a pain to add them by hand.

Bryan