q on ALTER TABLE ... DROP COLUMN

Question

See picture in:
https://app.box.com/s/tshious8f5kzhr8u90aq29whlpxr46o9

ALTER TABLE People
DROP DateOfBirth

This works perfectly fine, so then why did they even bother with writing in additionally "COLUMN" right after "DROP" in the Tutorial/Lesson as shown on the PIC above? Seems redundant to have the"COLUMN" bit, right? Thank you :)

Answer 1

Its as pe default syntax of ANSI sql standard. By default it will seach of col to be dropped. If col is not present by that name, it will throw error message