Altova DatabaseSpy 2023 Enterprise Edition

Introduction
The DatabaseSpy Interface
Tutorials
- "Nanonull" Database
- "ZooDB" Database
Connecting to a Data Source
DatabaseSpy Projects
Managing Database Objects
Retrieving and Editing Data
Displaying Charts
SQL Editor
XML Management
Importing Database Data
- Defining XML Import Options
- Defining CSV Import Options
Exporting Database Data
DatabaseSpy Settings
Altova Global Resources
Menu Commands
License Information

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

- A -

Activating
- row count
- toolbars
Adding
ADO
- as data connection interface
- setting up a connection
ADO.NET
- setting up a connection
Appending
- rows with copied data
- semi-colons to statement end
Application startup
Applying SQL formatting
Auto layout
- selected tables
- whole diagram
Autocompletion
Autoinsertion

- B -

Block comment
- inserting
- removing
Bookmark margin
Bookmarks

- C -

Cascade
Case sensitivity
Change script
Change Script window
- toggling on and off
Changing
Charts
Charts window
- toggling on and off
Check constraints
Choosing
- active configuration
Closing
Collapsing
- regions
Column
Columns
Comments
- deleting
- removing
Conditional formatting
- in Result window
Configuration
Configuring DatabaseSpy
- Design Editor settings
- SQL Editor settings
Connecting
Connection method
Connection Wizard
- skipping configuration step
Constaints
Context menu
Copying
Copyright information
CREATE statements
- generating
Creating
CSV
- import data from
Customizing
Cutting text in SQL Editor

- D -

Data Inspector
- saving cell content
- toggling on and off
Data source
- assigning to SQL Editor window
- connecting on execute
Database
Database connection
Database data
Database drivers
- overview
Database Structure Change Script
- generating
Database Structure Change Script window
- toggling on and off
DatabaseSpy
DatabaseSpy as default editor
DatabaseSpy Tutorial
DDL scripts
- generating
Deactivating
- row count
Default
Default constraints
Default value
- in new rows
Defining
DELETE statements
- generating
Deleting
Deleting records
- manually
Design Editor
Design Editor menu
Diagrams
Display mode
- separate result tabs
- split result tab
Displaying
Distribution
- of Altova's software products
Dragging and dropping
- database objects into SQL Editor windows
Dropping

- E -

Edit menu
Editing
Editing records
- manually
Enabling
Encoding
End of line markers
End User License Agreement
Entry helper buffer
Escape characters
Evaluation period
- of Altova's software products
Executing
Execution timeout
Exiting DatabaseSpy
Expanding
Exporting

- F -

Favorites
- adding objects as
File DSN
- setting up
File extensions
- adding
- deleting
File menu
Files
Finding
Firebird
- Connecting through JDBC
- Connecting through ODBC
Folding margin
Foreign keys
Formatting
- removing
- SQL statements
Frame title
Full row selection

- G -

General options
Generating
Global resources
Grid
- colors in result view
- settings in Design Editor

- H -

Help menu
Hotkeys

- I -

IBM DB2
- connecting through JDBC
- connecting through ODBC
IBM DB2 for i
- connecting through JDBC
- connecting through ODBC
IBM Informix
- connecting through JDBC
Importing
Indentation guides
Indexes
INSERT statements
- executing
- generating
Inserting
Inserting records
- manually
- via INSERT statements

- J -

JDBC

- K -

Keyboard shortcuts

- L -

Layout
Legal information
License
- information about
License metering
- in Altova products
Line breaks
Line comment
- inserting
- removing
Line number margin

- M -

Margins
MariaDB
- connect through ODBC
Memory requirements
Menu
Menus
- changing the appearance of
- customizing
Message view
- toggling on and off
Microsoft Access
- connecting through ADO
Microsoft Excel
- pasting cell ranges from
Microsoft SQL Server
- connecting through ADO
- connecting through ODBC
MySQL
- connecting through ODBC

- N -

Navigating
- bookmarks

- O -

ODBC
ODBC Drivers
- checking availability of
OLE DB
- as data connection interface
Online Browser
Opening
OpenJDK
- as Java Virtual Machine
Operating system
- for Altova products
Options
Oracle database
- connecting through JDBC
- connecting through ODBC
OS
- for Altova products
Output window
- toggling on and off
Overview window
- toggling on and off

- P -

Parameters
- in SQL statements
Pasting
Pinning
- Result tab
Platforms
- for Altova products
PostgreSQL
- connecting natively
- connecting through ODBC
Primary keys
Print preview
Print setup
Printing
Program logo
Progress OpenEdge database
- connecting through JDBC
- connecting through ODBC
Project
Project window
Projects
Properties
- changing
- viewing
Property window
- toggling on and off

- Q -

Queries
- creating from Select statements
Quitting DatabaseSpy
Quotations
- adding to identifiers
- removing from identifiers

- R -

Redo command
Reducing vertical spacing
Regions
Regular expressions
- searching SQL Editor
Relations
- hiding labels of unselected
- highlight active objects
Reloading files
Removing
Renaming
- toolbar
- user-defined tools
Reparsing SQL statements
Replacing
- text in SQL Editor
Resetting
- all toolbars
- toolbars
Result tab
Result view
- viewing statistics
Result window
Results
- in separate tabs
- in split result tab
Resuming
- data retrieval
Retrieval
- timeout
Retrieving data
Row count

- S -

- T -

Tab size
Tab width
Table
Tables
Target
- inserting
Target name
Teradata
- connect through JDBC
- connect through ODBC
Text View Settings
Tile horizontally
Tile vertically
Toolbar
Tools
Tools menu
Transactions
Triggers
- overview

- U -

Undo command
Unique keys
Unpinning
- Result tab
UPDATE statements
- generating
Updating
User DSN
- setting up
User Reference
- menu items
User-defined tools

- V -

View
- creating from Select statements
View menu
Viewing
Views
Visual aid

- W -

Whitespace markers
Window list
Window menu
Windows
Windows dialog box
Windows explorer settings
Word wrap
- in SQL View
Wrapping text when autoinserting

- X -

XML
- export data to
- import data from
XML columns
- editing
XML databases
- support notes
XML schema management
XML Schemas
XML types
- support notes
XMLSpy
- viewing XML schemas in

- Y -

- Z -

Zooming

Navigation: Menu Commands > File Menu > New

SQL Editor

Home Prev Top Next

ic_new-sql-editor

Ctrl+N

The SQL Editor command opens a new SQL Editor window.

© 2017-2023 Altova GmbH