You need to change the foreign key constraint on a column. Below is the SQL you are using but it is generating an error. What is the error?

alter table order

alter constraint order$\_$customerid$\_$fk foreign key $($customerid$)$

references customer$($customerid$)$;

Which one of these is the right answer

A$.$ There is no alter constraint command in SQL$.$ In order to make changes to the constraint you need to drop the table and recreate it with the new constraint.

B$.$ There is no alter constraint command in SQL$.$ In order to make changes to a constraint you need to add another constraint to this column.

C$.$ The alter constraint statement needs to appear first.

D$.$ There is nothing wrong with this statement.