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

A.ALTER TABLE Student DELECT Birthyear RESTRICT

B.ALTER TABLE Student DELETE Birthyear CASCADE

C.ALTER TABLE Student DROP Birthyear RESTRICT

D.ALTER TABLE Student DROP Birthyear CASCADE