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