Add Foreign Key in SQL SERVER 2012

    ALTER TABLE tbl_Users
ADD CONSTRAINT fk_users_RoleId FOREIGN KEY (RoleId)
    REFERENCES tbl_Roles (RoleId)
    ON DELETE CASCADE
    ON UPDATE CASCADE