Column.DefaultConstraint Property

Gets a default value for the column.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.ZeroToOne, SfcObjectFlags.Design)> _
Public Property DefaultConstraint As DefaultConstraint
    Get
    Friend Set
'Usage
Dim instance As Column
Dim value As DefaultConstraint

value = instance.DefaultConstraint
[SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.ZeroToOne, SfcObjectFlags.Design)]
public DefaultConstraint DefaultConstraint { get; internal set; }
[SfcObjectAttribute(SfcObjectRelationship::ChildObject, SfcObjectCardinality::ZeroToOne, SfcObjectFlags::Design)]
public:
property DefaultConstraint^ DefaultConstraint {
    DefaultConstraint^ get ();
    internal: void set (DefaultConstraint^ value);
}
[<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.ZeroToOne, SfcObjectFlags.Design)>]
member DefaultConstraint : DefaultConstraint with get, internal set
function get DefaultConstraint () : DefaultConstraint
internal function set DefaultConstraint (value : DefaultConstraint)

Property Value

Type: Microsoft.SqlServer.Management.Smo.DefaultConstraint
A DefaultConstraint value that specifies a default value for the column.

Remarks

The DefaultConstraint property specifies a default text value for the column. When no value is supplied by the user, the default text value is inserted into a row in the table. The text value can be set by setting the Text property of the DefaultConstraint object that is referenced by the DefaultConstraint property.