Separate "Collapse parentheses if contents are shorter than..." option from Primary Keys
In SQL Prompt, Formatting Styles, I would like to differentiate the “Short parentheses contents” behavior, so it didn’t impact the primary key when I add a Constraint Primary Key Clustered at Create Table time.
I like my PK fields to stand out, not hide in a block of text.
But I also like any other listing of a few fields to be kept on a single line, and not bloating the screen for no reason at all.
Currently, I can’t have both.
In short, I want
CREATE TABLE dbo.Orders
(
OrderDate DATETIME NOT NULL,
OrderID INT NOT NULL,
CustomerID INT NULL,
CONSTRAINT PKOrders
PRIMARY KEY CLUSTERED (
OrderDate ASC,
OrderID ASC
)
WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON,
ALLOWPAGE_LOCKS = ON
) ON [PRIMARY]
) ON [PRIMARY];
instead of this:
CREATE TABLE dbo.Orders
(
OrderDate DATETIME NOT NULL,
OrderID INT NOT NULL,
CustomerID INT NULL,
CONSTRAINT PKOrders
PRIMARY KEY CLUSTERED (OrderDate ASC, OrderID ASC)
WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON,
ALLOWPAGE_LOCKS = ON
) ON [PRIMARY]
) ON [PRIMARY];
![](https://secure.gravatar.com/avatar/85c281927f49b02ddcefc6c1f7da69f8?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)