DropDestObjectsFirst Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DropDestObjectsFirst property manipulates Microsoft SQL Server database object copying.
Syntax
object
.DropDestObjectsFirst [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- Value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetDropDestObjectsFirst(LPBOOL pRetVal);
HRESULT SetDropDestObjectsFirst(BOOL NewValue);
Remarks
If TRUE, the transfer attempts to drop a database object from the target database before copying the object from the source database.
If FALSE, the transfer copies database objects.
Note
The value of the DropDestObjectsFirst property applies only if database objects are copied in the transfer. To copy database objects, the CopySchema property value must be TRUE.