Answers for "create table sql primary and foreign key"

drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

Posted by: Guest on June-04-2020

add constraint fk

ALTER TABLE Orders
ADD CONSTRAINT FK_PersonOrder
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

Posted by: Guest on September-02-2020

Code answers related to "create table sql primary and foreign key"