Question

Write a query to create a table exam in which fields Rno is primary key of type int, name

of type char, srno of type int(make it foreign key and give the reference table student). ​

Answer 1

Answer:

When you create a table in SQL, you usually want to specify an id column to be the primary key. That will make that value the unique identifier for the row in the table. You can write PRIMARY KEY after a column to make it the primary key.

Answer 2

Answer:

When you create a table in SQL, you usually want to specify an id column to be the primary key. That will make that value the unique identifier for the row in the table. You can write PRIMARY KEY after a column to make it the primary key.