Aracılığıyla paylaş

Column.DefaultConstraint Property

  • Makale

Gets a default value for the column.

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

Syntax

'Bildirim
<SfcObjectAttribute(SfcObjectRelationship.ChildObject, SfcObjectCardinality.ZeroToOne, SfcObjectFlags.Design)> _
Public Property DefaultConstraint As DefaultConstraint
    Get
    Friend Set
'Kullanım
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.

Examples

Working with Database Objects

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TABLE (Transact-SQL)

Constraints