It seems like you can't modify a constraint, so I dropped it (successfully). But now I don't know how to recreate a similar, updated one... I did it manually, but is there some tcodes that I can write for it to do the same thing?
Context: There were 6 types of status reports. now there are 12 of them with their own description. I needed to make sure the db could take all 12 of them.
ALTER TABLE Sales.SalesOrderHeader DROP CONSTRAINT CK_SalesOrderHeader_Status; --OK ALTER TABLE Sales.SalesOrderHeader ADD CONSTRAINT CK_SalesOrderHeader_Status CHECK (Status >=0 AND Status <=12); --????
