CopySchema 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 CopySchema property controls table creation on data transfer.

Syntax

object.CopySchema [=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 GetCopySchema(LPBOOL pRetVal);
HRESULT SetCopySchema(BOOL NewValue);

Remarks

If TRUE, transfer processing creates tables prior to attempting to copy data.

If FALSE, tables are not created prior to data copying. All tables indicated in the transfer operation must exist in the target database.

Applies To: