How can we help you today? How can we help you today?

What controls this formatting?

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.
Dave Pendleton
0

Comments

1 comment

Sort by
  • 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
    Anu D
    0

Add comment

Please sign in to leave a comment.