For security concerns, and to avoid accidental file damage, this EXPORT procedure does not export data into an existing file. You must specify a filename in the EXPORT procedure that does not exist. When you run the procedure the file is created and the data is exported into the new file.
The data is exported using a delimited file format.
For more information on using this procedure, see the section
"Importing and exporting data" in the
No result is returned from the procedure.
If authentication and SQL authorization are both enabled, only the
The following example shows how to export
the information about employees in Department 20 from the STAFF table in the
SAMPLE database to the