Constraint format

torsten.strauss

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

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