要删除 Student 表的Birthyear 列，同时删除所有引用该列

要删除 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;