You can't delete a column that has a CHECK constraint. You must first delete the constraint. If the column contains constraints or other dependencies, an error ...
ALTER TABLE adpwd ADD COLUMN IS_DELETE TINYINT(1) DEFAULT 0; ALTER TABLE ageofbuilding ADD COLUMN IS_DELETE TINYINT(1) DEFAULT 0; ALTER TABLE annualcost ADD COLUMN IS_DELETE TINYINT(1) DEFAULT 0; ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results