Avoid reformatting when creating a view

[Former Member]

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.

[Former Member]

That was it - thanks!!

[former_SQLA_member1694886]

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

[Breck_Carter]

In addition to Vincent's answer: The preserve_source_format option has existed for many years and the default has always been 'ON'.

If it is 'OFF' in your database, you should check all other database options to make sure the same [cough] evil influence hasn't damaged some other setting... 99.99% of the time in SQL Anywhere the defaults are what you want, as opposed to other DBMS products.