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

Comments

2 comments

  • RichardL
    Hi @torsten.strauss

    Sorry that this post fell through the net. 

    Just checking to see if this is still an issue? 

    Best

    Richard. 
    RichardL
    0
  • torsten.strauss
    Still an issue...
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.