Question Re: Avoid reformatting when creating a view in Technology Q&A

Avoid reformatting when creating a view

Former Member — Tue, 22 Apr 2014 02:21:42 GMT

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.

Re: Avoid reformatting when creating a view

former_SQLA_member1694886 — Tue, 22 Apr 2014 03:52:30 GMT

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

Re: Avoid reformatting when creating a view

Breck_Carter — Tue, 22 Apr 2014 08:56:40 GMT

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.

Re: Avoid reformatting when creating a view

Former Member — Tue, 22 Apr 2014 10:34:17 GMT

That was it - thanks!!