What does the UNIQUE constraint guarantee?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What does the UNIQUE constraint guarantee?

Key points

  • The UNIQUE constraint enforces uniqueness in a column or combination of columns.
  • It does not automatically index the column for faster queries.
  • It is not related to matching values in a referenced table.
  • It does not restrict the column from containing NULL values.

Ready to go further?

Start full exam Practice more questions

Related questions