Alter query to set foreign key

ALTER TABLE tablename_to_add_foreignkey ADD CONSTRAINT constraint_name FOREIGN KEY (fieldname) REFERENCES sports (reference_fieldname)