SQL-DMO
DropDestObjectsFirst Property
The DropDestObjectsFirst property manipulates Microsoft® SQL Server™ database object copying.
Applies To
Transfer Object |
Syntax
object.DropDestObjectsFirst [= value]
Parts
object
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 when database objects are copied in the transfer. To copy database objects, the CopySchema property value must be TRUE.