ScriptingOptions.DriPrimaryKey Property

Article
07/16/2015

Applies To: SQL Server 2016 Preview

Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in primary keys which have enforced declarative referential integrity are included in the script.

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

Syntax

public bool DriPrimaryKey { get; set; }

public:
property bool DriPrimaryKey {
    bool get();
    void set(bool value);
}

member DriPrimaryKey : bool with get, set

Public Property DriPrimaryKey As Boolean

Property Value

Type: System.Boolean

A Boolean value that specifies whether to script primary keys that have enforced declarative referential integrity.

If True, primary keys are included in the script. Otherwise, False (default).

Remarks

Scripting is directed to consider dependency relationships that have been established by declarative referential integrity.

Examples

Legacy Code Example

The following code example specifies that dependency relationships defined in primary keys which have enforced declarative referential integrity are scripted.

Visual Basic

Dim scOps As New ScriptingOptions()
scOps.DriPrimaryKey = true

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.DriPrimaryKey = $TRUE