miraclemaker
Programmer
When creating a primary key for a table, aswell as having it set as the primary key and auto-increment, is it good practice to also define it as being unique and being an indexing field?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Properties of Primary Key of table
- Thread starter miraclemaker
- Start date
- Status
sleipnir214
Programmer
By definition, a primary key column is a unique indexed column. Setting those attributes by hand would be redundant. Want the best answers? Ask the best questions: TANSTAAFL!
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question