What does a DEFAULT value on a column do?

SQL Fundamentals Easy

SQL Fundamentals — Easy

What does a DEFAULT value on a column do?

Key points

  • DEFAULT values are used to provide a default value when no value is specified during INSERT
  • They do not prevent values from being inserted or make the column read-only
  • DEFAULT values are not related to setting a column as a primary key

Ready to go further?

Related questions