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];