How can we help you today? How can we help you today?

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


torsten.strauss
0

Comments

1 comment

  • Jessica R
    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 R
    0

Add comment

Please sign in to leave a comment.