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

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.