Alignment

torsten.strauss

Hi Redgate Team,

this following code is formatted like shown:

ALTER TABLE SENTOSA.COMPONENTS_TO_MIGRATE
ADD
	CONSTRAINT UQ_COMPONENTS_TO_MIGRATE_COMPONENT_COMPONENT_NAME_COMPONENT_TYPE_PARENT_ID_DOMAIN_ID UNIQUE
		( COMPONENT_NAME, COMPONENT_TYPE, PARENT_ID, DOMAIN_ID )									WITH ( FILLFACTOR = 100 ) ON [DEFAULT];
GO

The with clause is aligned with the unique one.
There is no reason and no intention to do this.

Same is wrong with the following statement:

ALTER TABLE SENTOSA.COMPONENTS_TO_MIGRATE WITH CHECK
ADD
	CONSTRAINT FK_COMPONENT_COMPONENT FOREIGN KEY ( [PARENT_ID] ) REFERENCES SENTOSA.COMPONENTS_TO_MIGRATE
										  ( [COMPONENT_ID] );
GO

Would be nice if you can fix this!

Version 9.0.6.3580
Style attached ...

Thanks!

Torsten

RichardL

Hi @torsten.strauss

Sorry that this post fell through the net. 

Just checking to see if this is still an issue? 

Best

Richard. 

torsten.strauss

Still an issue...