Smaller formatting issue
torsten.strauss
Posts: 271 Silver 3
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?