DELETE
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN (
SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME))
FROM information_schema.COLUMNS AS COL
WHERE COL.TABLE_SCHEMA = 'jlink'
);
SELECT *
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN (
SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME))
FROM information_schema.COLUMNS AS COL
WHERE COL.TABLE_SCHEMA = 'jlink'
);
DELETE
FROM TB_VALIDATE_PARAM
WHERE UPPER(CONCA