How do I set primary keys and foreign keys in a table?

Answer 1

create table tablename (name(varchar).....) primary key = name

Answer 2

create table ***** (name(vachar).......... primary key=name

Answer 3

To add foreign key
Alter table tablename add constraint_name foreign key (column_name) references (column_name)

Answer 4

alter table table_name add constraint_name primary key (column1,column2,...);

You can create one primary key for each table not more than that but yes, you can select multiple columns if you want