What controls this formatting?

Dave Pendleton

What setting controls the following?

This is the closing parens of a CREATE TABLE statement.

)
    ON
[PRIMARY] ;

Why the indent of "ON", and "[PRIMARY]" on a new line?

Also I have been encountering situations where an object qualified with a non-dbo schema is inserting spaces around the period, e.g.

SELECT * FROM BASE.MyTable;

is reformatted as:

SELECT * FROM BASE . MyTable;

While this is legal syntax, I would prefer SP not exhibit this behavior.

Thanks.

Anu D

Hello Dave,

Thanks for your post.
For the 1st problem you need to change your settings.Kindly navigate to SQL Prompt --> Options --> Layout --> Schema Statements --> untick Place opening Parenthesis of definition on a new line and Place closing Parenthesis of definition on a new line options and this should solve the issue

For the 2nd problem
I tried to reproduce this, It is working fine for us. Can you kindly email us the steps to recreate it at support@red-gate.com.

Thanks