What are the challenges you face when working across database platforms? Take the survey
Options

What controls this formatting?

Dave PendletonDave Pendleton Posts: 104 Bronze 3
edited May 28, 2009 8:47AM in SQL Prompt Previous Versions
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.

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.