Computer Science, asked by anushkagehlot45, 7 months ago

You cannot enter ________ or _________ values in a Primary key field.

Answers

Answered by poojan
9

You cannot enter DUPLICATE or NULL values in a Primary key field.

Explanation:

  • The primary key field is a unique field in a table that helps in identifying the record in a database table.
  • Every table should contain one primary key and the values in those fields should be not-null and unique.
  • If there are more than one unique representation fields, such fields are known as composite key fields (Other than the one that is chosen as a primary key field).
  • Altering a primary key: ALTER TABLE TABLE_NAME ADD PRIMARY KEY (COLUMN_NAME);
  • Here, the column name should be the primary key field that holds the not-null and unique values. 'Id' can be the best example for the primary-key field, as no id number would be same or null.

Learn more:

1. What are the maximum and the minimum number of rows returned by the R1 right outer join R2?

brainly.in/question/21195376

2. Write an SQL command that selects all the information of family whose occupation is service using the information given...

https://brainly.in/question/15115256

Similar questions