Sql Alter Table Change

I created a table named STUDENT and define the primary key: studentID and two foreign keys: staffID and courseNo.

I need to give up my work table, drop table, but my state does not work, and even when I use the ALTER TABLE. What do I do now?

You must file the foreign key in another table / tables, including references to the table of students.

You'll need to "break" the relationship Situated between tables (foreign keys out) so that the table stands on its own. Then, delete or modify and recreate the relationship