ScriptingOptions.ScriptSchema Property
Gets or set the ScriptSchema property value.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
Public Property ScriptSchema As Boolean
public bool ScriptSchema { get; set; }
public:
property bool ScriptSchema {
bool get ();
void set (bool value);
}
/** @property */
public boolean get_ScriptSchema ()
/** @property */
public void set_ScriptSchema (boolean value)
public function get ScriptSchema () : boolean
public function set ScriptSchema (value : boolean)
Property Value
A Boolean value that indicates whether the schema is scripted. If True, the schema is scripted. Otherwise it is not.
Remarks
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. |
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.