sp_copy_directory system procedure

sp_copy_directory(
source_path
, destination_path
)

source_path Use this LONG NVARCHAR parameter to specify the path of the directory to copy. The path can be absolute or relative. A relative path is resolved on the computer relative to the current working directory of the database server. When the sandbox feature is enabled, the absolute and relative paths refer to the directory where the main database file is located.
destination_path Use this LONG NVARCHAR parameter to specify the path where the directory is copied to. The path can be absolute or relative. A relative path is resolved on the computer relative to the current working directory of the database server. When the sandbox feature is enabled, the absolute and relative paths refer to the directory where the main database file is located. The directory is created if it does not already exist

This function returns 0 on success and 1 on failure.

This function copies the directory and its files from the source directory to the specified directory. The directory and its files remain in the source directory. Use the sp_delete_directory system procedure to delete the source directory.

You must have the READ FILE and WRITE FILE system privileges.

The following statement makes a copy of the subdirectories and files in the SQLAnywhere directory in SQLAnywhere.bkp.

SELECT sp_copy_directory('c:\\sqlany\\samples\\SQLAnywhere', 'c:\\sqlany\\samples\\SQLAnywhere.bkp');

The entire directory including its subdirectories and files are duplicated.

sp_copy_directory system procedure

Syntax

Parameters

Returns

Remarks

Privileges

See also

Example