In this lesson, we will update the value and binding of our database column without delving into the table's properties.
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 [Execute] button
CFFCS | CarrzSynEdit: | SQL Script
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