Updating by Deletion
DELETE FROM ENROLMENT WHERE StudentId = SID ('S4');
As you can see, this differs from Example by the addition of the noise word FROM. The expression SID ('S4') assumes the existence of a user-defined operator whose invocation here yields the value of user-defined type SID that represents the student id S4.