What does the DEFAULT constraint do when defined on a column?

SQL Fundamentals Medium

SQL Fundamentals — Medium

What does the DEFAULT constraint do when defined on a column?

Key points

  • DEFAULT constraint supplies a value when INSERT statement omits it
  • Helps maintain data integrity by ensuring a default value is always present
  • Does not set the column to NULL or prevent other values from being inserted

Ready to go further?

Related questions