In this lesson, we will update the value and binding of our database column without going into the properties of the table itself.

Open SQL Server Management Studio
Right-Click on the database and choose [New Query]
Next, paste the following code and edit the [Table] and the [Column] value.
Next, click the [Ecxecute] button


ALTER TABLE TableName ADD CONSTRAINT col_1_def DEFAULT 'add your text in right here to add to the [Default Value and Binding]' FOR ColumnName