Propriété ScriptingOptions.DriNonClustered
SQL Server 2012
Gets or sets the Boolean property value that specifies whether dependency relationships that are defined in non-clustered indexes that have enforced declarative referential integrity are included in the script.
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Valeur de propriété
Type : System.BooleanA Boolean value that specifies whether to script non-clustered indexes that have enforced declarative referential integrity.If True, non-clustered indexes are included in the script. Otherwise, False (default).
The following code example specifies that the PRIMARY KEY constraints which use a unique index to implement declarative referential integrity will be scripted.
Visual Basic
Dim scOps As New ScriptingOptions() scOps.DriNonClustered = true
PowerShell
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions $scOps.DriNonClustered = $TRUE
