ASA SQL User's Guide
Transact-SQL Compatibility
Adaptive Server architectures
In addition to its own system tables, Adaptive Server Anywhere provides a set of system views that mimic relevant parts of the Adaptive Server Enterprise system tables. You'll find a list and individual descriptions in Views for Transact-SQL compatibility, which describes the system catalogs of the two products. This section provides a brief overview of the differences.
The Adaptive Server Anywhere system tables rest entirely within each database, while the Adaptive Server Enterprise system tables rest partly inside each database and partly in the master database. The Adaptive Server Anywhere architecture does not include a master database.
In Adaptive Server Enterprise, the database owner (user ID dbo) owns the system tables. In Adaptive Server Anywhere, the system owner (user ID SYS) owns the system tables. A dbo user ID owns the Adaptive Server Enterprise-compatible system views provided by Adaptive Server Anywhere.