Creating, Altering, and Removing Defaults

In SQL Server Management Objects (SMO), the default constraint is represented by the Default object.

The TextBody property of the Default object is used to set the value to be inserted. This can be a constant or a Transact-SQL statement that returns a constant value, such as GETDATE(). The TextBody property cannot be modified by using the Alter method. Instead, the Default object must be dropped and re-created.

See Also

Reference

Default

Other Resources

CREATE DEFAULT (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance