مشاركة عبر


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.

Examples

Working with Database Objects

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TABLE (Transact-SQL)

Constraints