Constraint format
torsten.strauss
Posts: 268 Silver 3
in SQL Prompt
Hi Redgate Team,
SQL Prompt formats the following code like:
Would be nice to get rid of the tabs - thanks!
Version 9.0.10.4053
Style is attached.
Regards
Torsten
SQL Prompt formats the following code like:
ALTER TABLE SYNTO.RPT_ELEMENT ADD CONSTRAINT PKCL_RPT_ELEMENT_ID_RPT_ELEMENT_ELEMENT_TYPE_FUNCTION_NAME_ELEMENT_UID_ELEMENT_ISACTIVE PRIMARY KEY CLUSTERED ( ELEMENT_TYPE_FUNCTION_NAME, ELEMENT_UID, ELEMENT_ISACTIVE ) WITH ( FILLFACTOR = 100 , DATA_COMPRESSION = PAGE ) ON [DEFAULT]; GO
Would be nice to get rid of the tabs - thanks!
Version 9.0.10.4053
Style is attached.
Regards
Torsten
Tagged:
Answers
Thanks for reporting this issue with formatting ALTER CONSTRAINT .. WITH .
I've logged it as a bug under reference SP-6838 and we will get back in touch if we find a fix.
Best wishes,
Michael
Technical Lead, SQL Monitor