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 » Database rebuilds

 

Exporting a table schema

The Unload utility has options that allow you to unload only the table schema.

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

The statements required to recreate the schema and reload the specified tables are written to reload.sql in the client's current directory.

You can unload more than one table by separating the table names with a comma delimiter.

 Task
  • Run the dbunload command, specifying connection parameters using the -c option, the table(s) you want to export data for using the -t option, and whether you want to unload only the schema by specifying the -n option.

    For example, to export only the schema for the Employees table, run the following command:

    dbunload -c "DBN=demo;UID=DBA;PWD=sql" -n -t Employees

Results

The table schema is exported.

 See also