Alignment

torsten.strausstorsten.strauss Posts: 266 Silver 3
edited January 29, 2018 2:04PM in SQL Prompt
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

Answers

Sign In or Register to comment.