Forums » General Discussion

Thread: Views, formatting SQL


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
Lars Oberg
Views, formatting SQL
Posted: Sep 17, 2010 11:11 AM
  Click to reply to this thread Reply







Hello,

When doing an “Alter View”, the whole view SQL gets displayed on one
very long line (often 3000+ columns long!), which is not very easy to work with.
Format SQL does not work (unless you remove the CREATE VIEW, etc., and just
leave the actual SQL statement).

It would be very useful if the view were automatically displayed formatted so
that you can actually see what it does and/or edit it.

Is there a setting for this, or should I post a feature request somewhere (I am
new to Toad and this forum)?

Thanks,

Lars



__________ Information from ESET NOD32 Antivirus, version of virus signature
database 5458 (20100917) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com







Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums