Sybase ASE SQL Parser Support in GSP¶
This page documents the SQL syntax support for Sybase ASE in the General SQL Parser.
SAP Adaptive Server Enterprise (ASE) Transact-SQL. This vendor accepts only ASE syntax: Watcom-SQL forms (SQL Anywhere / IQ) and Sybase IQ DDL are rejected with errors naming the construct and the product. For scripts mixing the historical Sybase family, use the permissive sybase vendor.
Syntax Coverage Corpus¶
GSP tests Sybase ASE syntax against 69 documented constructs grouped into 34 categories, each cross-referenced to the documentation that defines it (1 distinct source page).
Parse coverage¶
Measured against GSP Java 4.2.6 on 2026-08-18 (UTC) (artifact sha256 44c4c247d5ee). Each construct below carries the complete set of examples from the Sybase ASE documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.
| Constructs fully parsed | Individual statements parsed | |
|---|---|---|
| All constructs | 58 of 69 (84%) | 232 of 245 (95%) |
| SELECT (queries) | 11 of 11 (100%) | 39 of 39 (100%) |
| DML (INSERT / UPDATE / DELETE / MERGE) | 3 of 5 (60%) | 12 of 14 (86%) |
| Stored procedures | 6 of 6 (100%) | 19 of 19 (100%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.
Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview
All 69 constructs¶
| Construct | Category | Parses | Specified in |
|---|---|---|---|
ALTER DATABASE |
ALTER | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
ALTER PROCEDURE |
ALTER | all 1 | SAP ASE (Adaptive Server Enterprise) reference |
ALTER TABLE |
ALTER | 7 of 8 | SAP ASE (Adaptive Server Enterprise) reference |
BEGIN END |
BEGIN | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
CASE |
CASE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE DATABASE |
CREATE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE DEFAULT |
CREATE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE EXISTING TABLE |
CREATE | all 1 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE FUNCTION |
CREATE | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE INDEX |
CREATE | all 5 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE OR REPLACE PROCEDURE |
CREATE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE PROCEDURE |
CREATE | all 7 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE PROXY_TABLE |
CREATE | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE ROLE |
CREATE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE RULE |
CREATE | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE SCHEMA |
CREATE | all 1 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE TABLE |
CREATE | all 6 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE TRIGGER |
CREATE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
CREATE VIEW |
CREATE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
OPEN FETCH CLOSE |
CURSOR | all 6 | SAP ASE (Adaptive Server Enterprise) reference |
DBCC |
DBCC | all 6 | SAP ASE (Adaptive Server Enterprise) reference |
DECLARE |
DECLARE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
DECLARE CURSOR |
DECLARE | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
DELETE |
DELETE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
DELETE STATISTICS |
DELETE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DISK INIT |
DISK | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
DROP DATABASE |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP DEFAULT |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP FUNCTION |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP INDEX |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP PROCEDURE |
DROP | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
DROP ROLE |
DROP | all 1 | SAP ASE (Adaptive Server Enterprise) reference |
DROP RULE |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP TABLE |
DROP | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
DROP TRIGGER |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DROP VIEW |
DROP | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
DUMP DATABASE |
DUMP | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
DUMP TRANSACTION |
DUMP | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
EXECUTE |
EXECUTE | all 7 | SAP ASE (Adaptive Server Enterprise) reference |
GOTO |
GOTO | all 6 | SAP ASE (Adaptive Server Enterprise) reference |
GRANT |
GRANT | 7 of 8 | SAP ASE (Adaptive Server Enterprise) reference |
IF ELSE |
IF | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
INSERT |
INSERT | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
LOAD DATABASE |
LOAD | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
LOAD TRANSACTION |
LOAD | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
LOCK TABLE |
LOCK | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
ONLINE DATABASE |
ONLINE | 0 of 1 | SAP ASE (Adaptive Server Enterprise) reference |
PRINT |
all 5 | SAP ASE (Adaptive Server Enterprise) reference | |
RAISERROR |
RAISERROR | all 5 | SAP ASE (Adaptive Server Enterprise) reference |
READTEXT |
READTEXT | all 1 | SAP ASE (Adaptive Server Enterprise) reference |
RETURN |
RETURN | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
REVOKE |
REVOKE | 5 of 7 | SAP ASE (Adaptive Server Enterprise) reference |
COMPUTE |
SELECT | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
GLOBAL VARIABLES |
SELECT | all 6 | SAP ASE (Adaptive Server Enterprise) reference |
ORDER BY |
SELECT | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
SELECT |
SELECT | all 13 | SAP ASE (Adaptive Server Enterprise) reference |
SELECT INTO |
SELECT | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
SUBQUERY |
SELECT | all 5 | SAP ASE (Adaptive Server Enterprise) reference |
SET |
SET | all 10 | SAP ASE (Adaptive Server Enterprise) reference |
SET IDENTITY_INSERT |
SET | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
SETUSER |
SETUSER | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
TRANSACTION |
TRANSACTION | all 9 | SAP ASE (Adaptive Server Enterprise) reference |
TRUNCATE TABLE |
TRUNCATE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
UPDATE |
UPDATE | all 4 | SAP ASE (Adaptive Server Enterprise) reference |
UPDATE STATISTICS |
UPDATE | 5 of 6 | SAP ASE (Adaptive Server Enterprise) reference |
USE |
USE | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
WAITFOR |
WAITFOR | all 2 | SAP ASE (Adaptive Server Enterprise) reference |
WHILE |
WHILE | all 3 | SAP ASE (Adaptive Server Enterprise) reference |
WRITETEXT |
WRITETEXT | 0 of 2 | SAP ASE (Adaptive Server Enterprise) reference |