cancel
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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.

View Entire Topic

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