Replace a global default value with a default value
- In the Database window, click Database Diagrams
under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
- If necessary, right-click the table and select Column Properties, Column Names, Keys, or Custom View from the shortcut menu.
- Assign a new default value to the column you want to change.
- A message prompts you to permanently unbind the existing default in order for the new default to be applied. Choose OK.