Articolo
09/28/2010

Proprietà ScriptData

Gets or sets the ScriptData property value.

Spazio dei nomi: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Property ScriptData As Boolean
    Get
    Set
'Utilizzo
Dim instance As ScriptingOptions
Dim value As Boolean

value = instance.ScriptData

instance.ScriptData = value

public bool ScriptData { get; set; }

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

member ScriptData : bool with get, set

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

Valore proprietà

Tipo: System. . :: . .Boolean
A Boolean value that indicates whether data is scripted.
If True, data is scripted. Otherwise, False.

Osservazioni

The table indicates the scripting behavior based on the combination of ScriptSchema, ScriptData, and ScriptDrops property values.

Property Values	Scripting Behavior
ScriptSchema = True ScriptData = False ScriptDrops = False	Only the schema will be scripted. This is the default.
ScriptSchema = True ScriptData = True ScriptDrops = False	Both the schema and the data will be scripted. The Drop statement for existing data will not be scripted because the script generated will first create the table and then insert the data. Data does not exist in the tables to begin with.
ScriptSchema = True ScriptData = False ScriptDrops = True	Only statements for objects to be dropped will be scripted.
ScriptSchema = True ScriptData = True ScriptDrops = True	The script will contain Drop statement for objects. Because data will be deleted when the objects are dropped, Delete statements will not be scripted.
ScriptSchema = False ScriptData = False ScriptDrops = any value	An error will be raised informing the user that at least one of ScriptSchema and ScriptData properties must be set to true.
ScriptSchema = False ScriptData = True ScriptDrops = False	Only the data will be scripted. Delete statements for removing existing data before inserting new data will not be scripted.
ScriptSchema = False ScriptData = True ScriptDrops = True	Only the script for dropping data will be generated. This behavior is consistent with how the schema is handled.

Vedere anche

Riferimento

ScriptingOptions Classe

Membri ScriptingOptions

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Condividi tramite