ScriptingOptions.DriAllKeys Property
SQL Server 2012
Gets or sets the Boolean property value that specifies whether the dependency relationships defined by all declarative referential integrity keys are included in the generated script.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
'Declaration Public Property DriAllKeys As Boolean Get Set 'Usage Dim instance As ScriptingOptions Dim value As Boolean value = instance.DriAllKeys instance.DriAllKeys = value
Property Value
Type: System.BooleanA Boolean value that specifies whether to script all DRI keys.If True, all key objects with enforced declarative referential integrity are included in the script. Otherwise, False (default).
The following code example specifies that all constraint objects with enforced declarative referential integrity will be scripted.
Visual Basic
Dim scOps As New ScriptingOptions() scOps.DriAllKeys = true
PowerShell
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions $scOps.DriAllKeys = $TRUE
