Preview Large Tables with Row-Limited SQL Queries
Altova DatabaseSpy 2027 adds SELECT statement generation with row limits and offsets, helping developers preview large tables and retrieve manageable results.

Altova DatabaseSpy is a multi-database query and design tool that provides SQL editing, graphical database design, and data content management in a single interface. Developers can connect to multiple relational database types to write queries, modify database structures, and work with stored data.
The Altova DatabaseSpy 2027 release adds the ability to generate SELECT statements that return a specified number of rows, optionally starting at a chosen row. This helps developers preview large tables, page through results, and test queries without retrieving the entire result set. DatabaseSpy detects the database type and generates the appropriate syntax for limits and offsets, reducing the need to manually adapt statements for different database systems.
To see a full list of what's new in 2027, see our release notes.
Altova DatabaseSpy is licensed per Installed, Concurrent or Named user. Licenses are perpetual, and come with or without 1 year Support and Maintenance Package (SMP). See our Altova DatabaseSpy licensing page for full details.
Altova DatabaseSpy is available individually or as part of Altova MissionKit.