You cannot enter ________ or _________ values in a Primary key field.
Answers
Answered by
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