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 » SQL script files

 

Loading a SQL script from a file into the SQL Statements pane

In Interactive SQL, you can load a SQL script file into the SQL Statements pane and execute it directly from there.

Prérequis

Interactive SQL is set up as the default editor for .sql files.

In Interactive SQL, click Tools » Options » General and then click Make Interactive SQL the default editor for .SQL files and plan files.

The privileges required depend on the statements being executed.

 Task
  1. Click File » Open.

  2. Locate the file, and click Open.

Résultat

The statements are displayed in the SQL Statements pane where you can read, edit, or execute them.