ScriptingOptions.ScriptDrops 속성
Gets or sets the Boolean property value that specifies whether the script operation generates a Transact-SQL script to remove the referenced component.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Property ScriptDrops As Boolean
Get
Set
‘사용 방법
Dim instance As ScriptingOptions
Dim value As Boolean
value = instance.ScriptDrops
instance.ScriptDrops = value
public bool ScriptDrops { get; set; }
public:
property bool ScriptDrops {
bool get ();
void set (bool value);
}
member ScriptDrops : bool with get, set
function get ScriptDrops () : boolean
function set ScriptDrops (value : boolean)
속성 값
유형: System.Boolean
A Boolean value that specifies whether to include drop clauses to remove objects in the generated script.If True, the script operation generates a Transact-SQL script to remove the referenced component.If False (default), the script operation generates a Transact-SQL script to create the referenced component.
주의
If the option is set to True, the script tests for existence before attempting to remove an object.
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. |
예
The following code example specifies that the referenced component will be dropped after the script is run.
Visual Basic
Dim scOps As New ScriptingOptions()
scOps.ScriptDrops = true
PowerShell
$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.ScriptDrops = $TRUE
참고 항목
참조
Microsoft.SqlServer.Management.Smo 네임스페이스