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

Constraint format

Hi Redgate Team,

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
torsten.strauss
0

Comments

1 comment

Sort by
  • Michael Clark
    Hi @torsten.strauss,

    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
    Michael Clark
    0

Add comment

Please sign in to leave a comment.