DropDestObjectsFirst Property (SQL-DMO)

The DropDestObjectsFirst property manipulates Microsoft® SQL Server™ database object copying.

Applies To

Syntax

object.DropDestObjectsFirst [= value]

Part	Description
object	Expression that evaluates to an object in the Applies To list
Value	True or False

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.

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetDropDestObjectsFirst(LPBOOL pRetVal);

HRESULT SetDropDestObjectsFirst(BOOL NewValue);