Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.
Smaller formatting issue

in SQL Prompt
Hi Redgate Team,
It would be nice to see the UNIQUE CLUSTERED aligned to the other columns,.
Thanks
CREATE TYPE products.product_price AS TABLE
It would be nice to see the UNIQUE CLUSTERED aligned to the other columns,.
Thanks
CREATE TYPE products.product_price AS TABLE
(
sap_location char(5) NOT NULL
, sap_product char(9) NOT NULL
, product_price decimal(9, 5) NOT NULL
, effective_date_time datetime2(2) NOT NULL
, ID_validity status.ID_status
, ID_status status.ID_status
,
UNIQUE CLUSTERED (
sap_location
, sap_product
, effective_date_time
)
);
GO
Tagged:
Answers
Thanks for your post!
I know these may not be preferred options, but it may be worth noting that either of the following allows the UNIQUE CLUSTERED to be aligned to the other columns.
or
- Statements>Schema>enable Place constraints on new lines
Would either of these work?
Jessica Ramos | Product Support Engineer | Redgate Software
Have you visited our Help Center?