This topic has not yet been rated - Rate this topic

Parameter.DefaultValue Property

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008
SQL Server 2005

Gets or sets the default value of the parameter.

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public string DefaultValue { get; set; }

Property Value

Type: System.String
A String value that specifies the default value of the parameter.

Examples

Creating, Altering, and Removing Stored Procedures

Creating, Altering, and Removing Indexes

Reference

Parameter Class

Microsoft.SqlServer.Management.Smo Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD