Set Primary Key and Foreign Key to Table using SQL Query

Primary Key:

ALTER TABLE Table_name ADD PRIMARY KEY (SID);

Foreign Key:

ALTER TABLE table_name
ADD CONSTRAINT FK_table_name1_Id FOREIGN KEY (tablename1Id) REFERENCES table_name1(Id)