Dela via

  • Artikel

ScriptingOptions.NoIdentities Property

Gets or sets the Boolean property value that specifies whether definitions of identity property seed and increment are included in the generated script.

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

Syntax

'Declaration
Public Property NoIdentities As Boolean
    Get
    Set
'Usage
Dim instance As ScriptingOptions
Dim value As Boolean

value = instance.NoIdentities

instance.NoIdentities = value

public bool NoIdentities { get; set; }

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

member NoIdentities : bool with get, set

function get NoIdentities () : boolean
function set NoIdentities (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether definitions of identity property seed and increment are included in the generated script.
If True, definitions of identity property seed and increment are not included in the generated script. Otherwise, False (default).

Remarks

This option applies only when scripting references a SQL Server table.

Examples

The following code example specifies that the definitions of identity property seeds and increments will not be scripted.

Visual Basic

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

PowerShell

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