Smaller formatting issue

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
(
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


Answers

  • Jessica RJessica R Posts: 1,319 Rose Gold 4
    Hi @torsten.strauss,

    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.
     
    - Lists>Commas>choose Place commas after items

    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?


Sign In or Register to comment.