【单选题】

要删除 Student 表的Birthyear 列，同时删除所有引用该列的视图和约束。下列哪一个SQL语句正确表达了这一删除要求?

A. ALTER TABLE Student DROP Birthyear RESTRICT;
B. ALTER TABLE Student DROP Birthyear RESTRICT;
C. ALTER TABLE Student DROP Birthyear RESTRICT;
D. ALTER TABLE Student. DELETE Birthyear CASCADE;