The main things to understand about a DEFAULT constraint are -
1. DEFAULTs are only used in INSERT statements- They are ignored for UPDATE and DELETE statements.2. If any value is supplied in the INSERT then the default is not used. 3. If no values supplied the default will always be used.