CODE EXAMPLE FOR SQL

add column with foreign key constraint sql server

ALTER TABLE one
    ADD two_id INTEGER,
    ADD CONSTRAINT FOREIGN KEY(two_id) REFERENCES two(id);