should drop constraint when change colulmn (rename, delete, change reference type)

Description

test case:
1. create column TH_FA_AssetRefute_Acct on table a_asset
2. set Reference = account
run sync cloumn, so it create constrain name THFAAssetRefuteAcct_AAsset to table C_VALIDCOMBINATION

3. set reference = table
4. set reference key = account_id
5. run sync column, show error about dupplicate constrain name

it's same when run 2pack. bellow function don't return any constrain, because reference table is new one.
rs = md.getCrossReference(catalog, schema, referenceTableName, catalog, schema, tableName);

solution: on after save of mcolumn, check condition and do drop constrain

Environment

None

Status

Assignee

Unassigned

Reporter

Hiep Lq

Labels

None

Tested By

None

Priority

Major
Configure