Previous Article SQL Server Management Studio - List all tables in a database |
SQL Server Management Studio - How to alter the default value or binding of a table column |
Next Article SQL Server Management Studio - Change Table Owner |
Coding Article #: 1088 - Published On: February 13, 2021 @ 04:00:23 AM - Last Updated on: January 01, 1900
This article has been Favorited 0 timesJoin today, and add this to your favorites.
Share With Friends (Updated 6-8-2010)
Supported Files
No Files for this Article.
No Files for this Article.
No Screenshot Available
In this lesson, we are going to 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
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
Post to Facebook about: SQL Server Management Studio - How to alter the default value or binding of a table column