Failed to drop default value in MSSQL

Description

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.0.7:update (default-cli) on project networx-data: Error setting up or running Liquibase: Migration failed for change set changelog-5.10.002.000.xml::17::xxx:
[ERROR] Reason: liquibase.exception.DatabaseException: Error executing SQL DECLARE @default sysname
[ERROR] SELECT @default = object_name(default_object_id) FROM sys.columns WHERE object_id=object_id('null.MigrationNotification') AND name='Status'
[ERROR] EXEC ('ALTER TABLE [MigrationNotification] DROP CONSTRAINT ' + @default): Incorrect syntax near 'CONSTRAINT'.

Environment

MSSQL 2008 R2

Activity

Show:
Dmitry Gil
November 20, 2013, 7:51 AM
Edited
Nathan Voxland
November 25, 2013, 10:44 PM

Fixed by related issues

Fixed

Reporter

Dmitry Gil

Fix versions

Affects versions

Priority

Blocker