Adding foreign key to a table

ALTER TABLE table name ADD CONSTRAINT FOREIGN KEY (columnname) REFERENCES tablename(columnname)