Fix CHECK syntax

[zier-one]

Index Issue: pingcap/tidb#11486

These are bad (incompatible) SQL cases:

ALTER TABLE d_n.t_n DROP CHECK ident
ALTER TABLE t_n LOCK = DEFAULT , DROP CHECK ident
ALTER TABLE t_n ALTER CHECK ident ENFORCED 

Claim this subtask based on the comments below this issue.