Skip to content

SAP SQL Anywhere Data Dictionary & SQL Catalog

from sqlspec.data_dictionary import get_data_dictionary_loader, get_dialect_config

config = get_dialect_config("sqlanywhere")

Introspects SAP SQL Anywhere SYS catalog views (SYS.SYSTAB, SYS.SYSTABCOL, SYS.SYSIDX, SYS.SYSIDXCOL, SYS.SYSFKEY, SYS.SYSCONSTRAINT, SYS.SYSVIEW, SYS.SYSPROCEDURE, SYS.SYSTRIGGER, SYS.SYSSEQUENCE). See the SAP SQL Anywhere Guide and Data Dictionary Guide for usage examples.

Dialect Configuration

Setting Value
Dialect Name sqlanywhere
Default Schema "DBA"
Version Pattern (\d+)\.(\d+)\.(\d+)
DDL Strategy AST synthesis + SYS.SYSTAB / SYS.SYSPROCEDURE definitions
Catalog .sql Files 9 files (16 named queries)

Capabilities & Type Mappings

Capability Status / Minimum Version Logical Type Target Physical Type
supports_arrays False AutoIncrement INTEGER DEFAULT AUTOINCREMENT
supports_clustering False bigint BIGINT
supports_cte True blob LONG BINARY
supports_for_update True boolean BIT
supports_in_memory False bytes VARBINARY(32767)
supports_json False date DATE
supports_merge True datetime TIMESTAMP
supports_on_conflict False decimal DECIMAL
supports_prepared_statements True float DOUBLE
supports_returning False integer INTEGER
supports_schemas True json LONG VARCHAR
supports_sequences True smallint SMALLINT
supports_skip_locked True string VARCHAR(255)
supports_transactional_ddl False text LONG VARCHAR
supports_transactions True time TIME
supports_update_from True timestamp TIMESTAMP
supports_upsert True uuid UNIQUEIDENTIFIER
supports_uuid True varchar VARCHAR(255)
supports_window_functions True - -
supports_cte >= 10.0.0 - -
supports_merge >= 11.0.0 - -
supports_window_functions >= 10.0.0 - -

Adapter Data Dictionary Classes

Catalog SQL Queries

The sqlanywhere dialect pack defines 16 named queries across 9 domain .sql files loaded via DataDictionaryLoader (sqlspec/data_dictionary/dialects/sqlanywhere/):

Domain Pack Source File Named Queries Bind Parameters
columns.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/columns.sql by_schema, by_table (2 named queries) :schema_name, :table_name
constraints.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/constraints.sql by_schema, by_table (2 named queries) :schema_name, :table_name
foreign_keys.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/foreign_keys.sql by_schema, by_table (2 named queries) :schema_name, :table_name
indexes.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/indexes.sql by_schema, by_table (2 named queries) :schema_name, :table_name
objects.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/objects.sql by_schema (1 named query) :object_name, :schema_name
schemas.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/schemas.sql by_schema, current (2 named queries) :schema_name
tables.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/tables.sql by_schema, all_by_schema, names_by_schema (3 named queries) :schema_name, :table_name
version.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/version.sql current (1 named query) none
views.sql sqlspec/data_dictionary/dialects/sqlanywhere/sql/views.sql by_schema (1 named query) :schema_name, :view_name