/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

Create table table1 (id int not null, val varchar(10))
Create table table2 (id int, t1id int, val varchar(10))

Alter table table1 add
        Constraint pk_table1 Primary Key (id)
    Alter table table2 Add
        Constraint fk_table1 Foreign Key (t1id) References table1(id)