Reported By: Sorin H Reported On: 4/21/2010 For: Version 2.03 Build 11
# 3189Cannot DROP a Column Used in a Constraint that is also DROPed in the Same ALTER TABLE Statement The following SQL raises the error:
Can not drop field "Id" ... it's used on index PrimaryKey
ALTER TABLE "MyTable"
DROP CONSTRAINT "PrimaryKey",
DROP COLUMN "Id"
ResolutionFixed Problem on 4/22/2010 in version 2.03 build 12
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB LCL Standard with Source ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial