Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Option to Format Index Statements

As a user it would be helpful to be able to customize how INDEX statements are formatted.

For example, it would be nice to be able to configure the indent for the second line where the "INCLUDE" statement is as shown below:

CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GO

Currently, SQL Complete formats the above text pushing the second line all the way to the left as shown below:

CREATE NONCLUSTERED INDEX [IXTableColumn] ON [dbo].[Table] ([Column1],[Column2], [Column3])
INCLUDE ([Column4],[Column5],[Column6])
GO

I am unable to find a current setting to indent the second line.

Thank you.

4 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Dawn commented  ·   ·  Report

    In addition to formatting indentations, it would be great if I could apply the comma before and stacked list formats to an index as in the example below.
    CREATE NONCLUSTERED COLUMNSTORE INDEX [NCCI_Name] ON [dbo].[some_table]
    (
    [id]
    ,[field1]
    ,[field2]
    ,[field3]
    ) WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [PRIMARY]
    GO