WL#12798: Implement ALTER TABLE ... DROP/ALTER CONSTRAINT syntax.

Affects: Server-8.0   —   Status: Complete

Currently MySQL supports only non-SQL standard syntax to DROP and     
ALTER table constraints.                                              
                                                                      
Goal of this WL is to support SQL standard syntax,                    
                                                                      
  "ALTER TABLE tbl_name DROP CONSTRAINT symbol"                       
                                                                      
to drop constraint and                                                
                                                                      
  "ALTER TABLE tbl_name ALTER CONSTRAINT symbol [NOT] ENFORCED"       
                                                                      
to alter constraint, where type of a constraint is automatically      
determined from the constraint name.                                  
                                                                      
However, the latter doesn't mean that we will support disabling       
constraints of types other than CHECK constraint. The plan is to only 
support generic syntax at this point.

Following bug is fixed by this WL:
BUG#3742 Foreign keys: DROP CONSTRAINT as a compatibility alias for DROP FOREIGN 
KEY