Jaa


Column.DefaultConstraint Property

Gets or sets a default value for the column.

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

Syntax

'Declaration
Public ReadOnly Property DefaultConstraint As DefaultConstraint
public DefaultConstraint DefaultConstraint { get; }
public:
property DefaultConstraint^ DefaultConstraint {
    DefaultConstraint^ get ();
}
/** @property */
public DefaultConstraint get_DefaultConstraint ()
public function get DefaultConstraint () : DefaultConstraint

Property Value

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Column Class
Column Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

CREATE TABLE (Transact-SQL)
Constraints
Working with Database Objects