Andrunevchyn

Recent Posts


Recent Comments


Archives


Categories


Meta


Andrunevchyn

notes and issue research


sql1

MS SqlServer: unique statement

Don’t use  UNIQUE statement like SqlServer will create constraint with random name like UQ__TableName__E39E26653F9E5D18 If you use some automation tool like Flyway you will not be able remove that constraint easily because each time when you recreate table you will get new constraint name Better solution is following in such case you can [...]

Andriy AndrunevchynAndriy Andrunevchyn