Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Executing SQL Commands

With the help of SQL commands you can control the database directly, and can also create and edit tables and queries.

Not all database types support all SQL instructions. If necessary, find out which SQL commands are supported by your database system.

To execute an SQL statement directly

  1. Choose File - Open to open a database file.

  2. Choose Tools - SQL.

  3. Click the Create Query in SQL View icon or

Select an existing query from the list and click the Edit icon .

  1. In the Query window, choose View - Switch Design View On/Off. Enter the SQL command that you want to execute, or edit an existing SQL command according to your requirements.

  2. Click the Run icon . The result of the query is displayed in the upper window.

  3. Click the Save or Save As icon to save the query.