• Article

ScriptingOptions.TimestampToBinary Property

Gets or sets the Boolean property value that specifies whether to convert timestamp data types to binary(8) data types when scripting the creation of a table or user-defined data type.

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

Syntax

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

value = instance.TimestampToBinary

instance.TimestampToBinary = value

public bool TimestampToBinary { get; set; }

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

member TimestampToBinary : bool with get, set

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

Property Value

Type: System.Boolean
A Boolean value that specifies whether to convert timestamp data types to binary(8) data types.
If True, timestamp data types are converted to binary(8) data types. Otherwise, False (default).

Examples

The following code example specifies that timestamp data will be converted to binary when scripting the creation of tables or user-defined data types.

Visual Basic

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

PowerShell

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