Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Data export

 

Exporting data with the Unload Data window

You can unload tables in Sybase Central using the Unload Data window.

Prerequisites

You must be the owner of the table, have SELECT privilege on the table, or have the SELECT ANY TABLE system privilege.

Context and remarks

You can use the Unload Data window in Sybase Central to unload one or more tables in a database. This functionality is also available with either the Unload Database Wizard or the Unload utility (dbunload), but this window allows you to unload tables in one step, instead of completing the entire Unload Database Wizard.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Double-click Tables.

  3. Right-click the table you want to export data from, and click Unload Data.

  4. Complete the Unload Data window. Click OK.

Results

The data is saved to the specified file.