When I create complex views as normal sql queries, complete with comments and a style of indentation that I am comfortable with - - I find when I then create the view and come back to edit it -- it has been massively reformatted by sql anywhere.
Is there any way to preserve my desired formatting? I admit that my style is highly influenced by my experience with MS SQL Server, which does not do any reformatting of my views.
Request clarification before answering.
Make sure the preserve_source_format database option is on.
See
http://dcx.sybase.com/index.html#1201/en/dbadmin/preserve-source-format-dboptions.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.