When adding constraints to columns, is there any real difference between using syntax such as:
ALTER TABLE table
ADD CONSTRAINT constraintname TYPE(columnname);
versus
ALTER TABLE table
MODIFY (columnname CONSTRAINT constraintname TYPE);
They seem to do the same things. Both require the same information. I suppose to try and answer this myself, the only real difference is that adding should be used when a constraint doesn't already exist, and modify should be used when you're changing a constraint that already exists? However, when doing my hands-on assignment for my class, it said to make the names columns NOT NULL, it accepted my use of MODIFY. I checked my list of constraints and they were added. So does it really matter?