[BUG] JSQLParser 4.7 : MSQL : DROP KEY not parsed #1909

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

• DB Mysql ALTER TABLE <table_name> DROP KEY not parsed by jsqlparse
• Example: ALTER TABLE ANV_ALERT_ACKNOWLEDGE_TYPE DROP KEY ALERT_ACKNOWLEDGE_TYPE_ID_NUK_1; can't be parsed

SQL Example:

• Error stacktrace

  
  "("
  "COLUMN"
  "CONSTRAINT"
  "FOREIGN"
  "IF"
  "INDEX"
  "PRIMARY"
  "UNIQUE"
  <S_IDENTIFIER>
  <S_QUOTED_IDENTIFIER>
  
      at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:37141)
      at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:36968)
      at net.sf.jsqlparser.parser.CCJSqlParser.AlterExpression(CCJSqlParser.java:22041)
  

Software Information:

• JSqlParser version - com.github.jsqlparser:jsqlparser:4.7
• Database (MySQL)

Tips:

• ALTER TABLE <table_name> DROP INDEX is working good. DROP KEY alone not parsed