Export data with the UNLOAD TABLE statement

The UNLOAD TABLE statement lets you export data efficiently in text formats only. The UNLOAD TABLE statement exports one row per line, with values separated by a comma delimiter. To make reloading faster, the data is exported in order by primary key values.

Use the UNLOAD TABLE statement when you:

want to export entire tables in text format
are concerned about database performance
export data to a file on a client computer

Impact on the database

Example

Using the SQL Anywhere sample database, you can unload the Employees table to a text file named employee_data.csv by executing the following statement:

UNLOAD TABLE Employees TO 'employee_data.csv';

Because it is the database server that unloads the table, employee_data.csv specifies a file on the database server computer.

Export data with the UNLOAD TABLE statement

Impact on the database

Example

See also