Alphabetical list of SQL statements

There are many SQL statements supported by the software.

In this section:

ALLOCATE DESCRIPTOR statement [ESQL]

Allocates space for a SQL descriptor area (SQLDA).

ALTER DATABASE statement

Upgrades the database, turns jConnect support for a database on or off, calibrates the database, changes the transaction log and transaction log mirror file names, or forces a mirror server to take ownership of a database.

ALTER DBSPACE statement

Preallocates space for a dbspace or for the transaction log, or updates the catalog when a dbspace file is renamed or moved.

ALTER DOMAIN statement

Renames a user-defined domain or data type.

ALTER EVENT statement

Changes the definition of an event or its associated handler for automating predefined actions, or alters the definition of scheduled actions. You can also use this statement to hide the definition of an event handler.

ALTER EXTERNAL ENVIRONMENT statement

Specifies the location of an external environment such as Java, PHP, or Perl.

ALTER FUNCTION statement

Modifies a function.

ALTER INDEX statement

Renames an index, primary key, or foreign key, or changes the clustered nature of an index.

ALTER LDAP SERVER statement

Alters an LDAP server configuration object.

ALTER LOGIN POLICY statement

Alters an existing login policy.

ALTER MATERIALIZED VIEW statement

Alters a materialized view.

ALTER MIRROR SERVER statement

Modifies the attributes of a mirror server.

ALTER ODATA PRODUCER statement

Alters an OData Producer.

ALTER PROCEDURE statement

Modifies a procedure.

ALTER PUBLICATION statement [MobiLink] [SQL Remote]

Alters a publication. In MobiLink, a publication identifies synchronized data in a SQL Anywhere remote database. In SQL Remote, a publication identifies replicated data in both consolidated and remote databases.

ALTER REMOTE MESSAGE TYPE statement [SQL Remote]

Changes the publisher's message system, or the publisher's address for a given message system, for a message type that has been created.

ALTER ROLE statement

Migrates a compatibility role to a user-defined role, and then drops the compatibility role.

ALTER SEQUENCE statement

Alters a sequence.

ALTER SERVER statement

Modifies the attributes of a remote server.

ALTER SERVICE statement [HTTP web service]

Alters an existing HTTP web service.

ALTER SERVICE statement [SOAP web service]

Alters an existing SOAP or DISH service over HTTP.

ALTER SPATIAL REFERENCE SYSTEM statement

Changes the settings of an existing spatial reference system. See the Remarks section for considerations before altering a spatial reference system.

ALTER STATISTICS statement

Controls whether statistics are automatically updated on a column, or columns, in a table.

ALTER SYNCHRONIZATION PROFILE statement [MobiLink]

Changes a SQL Anywhere synchronization profile. Synchronization profiles are named collections of synchronization options that can be used to control synchronization.

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Alters the properties of a synchronization subscription in a SQL Anywhere remote database.

ALTER SYNCHRONIZATION USER statement [MobiLink]

Alters the properties of a MobiLink user in a SQL Anywhere remote database.

ALTER TABLE statement

Modifies a table definition or disables dependent views.

ALTER TEXT CONFIGURATION statement

Alters a text configuration object.

ALTER TEXT INDEX statement

Alters the definition of a text index.

ALTER TIME ZONE statement

Modifies a time zone object.

ALTER TRACE EVENT SESSION statement

Adds or removes trace events from a session, adds or removes targets from a session, or starts or stops a trace session.

ALTER TRIGGER statement

Replaces a trigger definition with a modified version. You must include the entire new trigger definition in the ALTER TRIGGER statement.

ALTER USER statement

Alters user settings.

ALTER VIEW statement

Replaces a view definition with a modified version.

ATTACH TRACING statement (deprecated)

The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. The ATTACH TRACING statement starts a diagnostic tracing session (starts sending diagnostic information to the diagnostic tables).

BACKUP DATABASE statement

Backs up a database and transaction log.

BEGIN statement

Specifies a compound statement.

BEGIN statement [TSQL]

Specifies a compound statement.

BEGIN PARALLEL WORK statement

Saves time when executing a list of CREATE INDEX or LOAD TABLE statements on a computer with multiple logical processors.

BEGIN TRANSACTION statement [T-SQL]

Begins a user-defined transaction.

BEGIN SNAPSHOT statement

Starts a snapshot at a specified period in time for use with snapshot isolation transactions.

BREAK statement [T-SQL]

Exits a compound statement or loop.

CALL statement

Invokes a procedure.

CASE statement

Selects an execution path based on multiple cases.

CASE statement [T-SQL]

Selects an execution path based on multiple cases.

CHECKPOINT statement

Checkpoints the database.

CLEAR statement [Interactive SQL]

Closes any open result sets in Interactive SQL.

CLOSE statement [ESQL] [SP]

Closes a cursor.

COMMENT statement

Stores a comment for a database object in the system tables.

COMMIT statement

Makes changes to the database permanent, or terminates a user-defined transaction.

CONFIGURE statement [Interactive SQL]

Opens the Interactive SQL Options window.

CONNECT statement [ESQL] [Interactive SQL]

Establishes a connection to a database.

CONTINUE statement

Restarts a loop.

CREATE CERTIFICATE statement

Adds or replaces a certificate in the database from the given file or string. To create a certificate, use the Certificate Creation utility (createcert).

CREATE DATABASE statement

Creates a database.

CREATE DBSPACE statement

Defines a new database space and creates the associated database file.

CREATE DECRYPTED DATABASE statement

Creates a decrypted copy of an existing database, including all transaction logs and dbspaces.

CREATE DECRYPTED FILE statement

Creates a decrypted copy of a strongly encrypted database, and can be used to create decrypted copies of transaction logs, transaction log mirrors, and dbspaces.

CREATE DOMAIN statement

Creates a domain in a database.

CREATE ENCRYPTED DATABASE statement

Creates an encrypted copy of an existing database, including all transaction logs and dbspaces; or creates a copy of an existing database with table encryption enabled.

CREATE ENCRYPTED FILE statement

Creates a strongly encrypted copy of a database file when you cannot use the CREATE ENCRYPTED DATABASE statement. Also creates encrypted copies of the transaction log, transaction log mirror, and dbspace files.

CREATE EVENT statement

Defines an event and its associated handler for automating predefined actions, and to define scheduled actions.

CREATE EXISTING TABLE statement

Creates a new proxy table, which represents an existing object on a remote server.

CREATE EXTERNLOGIN statement

Assigns an alternate login name and password to be used when communicating with a remote server.

CREATE FUNCTION statement [External call]

Creates an interface to a native or external function.

CREATE FUNCTION statement [Web service]

Creates a web client function that makes an HTTP or SOAP over HTTP request.

CREATE FUNCTION statement

Creates a user-defined SQL function in the database.

CREATE INDEX statement

Creates an index on a specified table or materialized view.

CREATE LDAP SERVER statement

Creates an LDAP server configuration object.

CREATE LOCAL TEMPORARY TABLE statement

Creates a local temporary table within a procedure that persists after the procedure completes and until it is either explicitly dropped, or until the connection terminates.

CREATE LOGIN POLICY statement

Creates a login policy.

CREATE MATERIALIZED VIEW statement

Creates a materialized view.

CREATE MESSAGE statement [T-SQL]

Creates a message number/message string pair. The message number can be used in PRINT and RAISERROR statements.

CREATE MIRROR SERVER statement

Creates or replaces a mirror server that is being used for database mirroring or read-only scale-out.

CREATE MUTEX statement

Creates or replaces a mutex (lock) that can be used to lock a resource such as a file or a procedure.

CREATE ODATA PRODUCER statement

Creates or replaces an OData Producer.

CREATE PROCEDURE statement [External call]

Creates an interface to a native or external procedure.

CREATE PROCEDURE statement [Web service]

Creates a user-defined web client procedure that makes HTTP or SOAP requests to an HTTP server.

CREATE PROCEDURE statement [T-SQL]

Creates a new procedure in the database in a manner compatible with Adaptive Server Enterprise.

CREATE PROCEDURE statement

Creates a user-defined SQL procedure in the database.

CREATE PUBLICATION statement [MobiLink] [SQL Remote]

Creates a publication. In MobiLink, a publication identifies synchronized data in a SQL Anywhere remote database. In SQL Remote, publications identify replicated data in both consolidated and remote databases.

CREATE REMOTE [MESSAGE] TYPE statement [SQL Remote]

Identifies a message link and return address for outgoing messages from a database.

CREATE ROLE statement

Creates or replaces a role, creates a user-extended role, or modifies administrators for a role.

CREATE SCHEMA statement

Creates a collection of tables and views for a database user.

CREATE SEMAPHORE statement

Creates or replaces a semaphore and establishes the initial value for its counter. A semaphore is a locking mechanism that uses a counter to communicate and control the availability of a resource such as an external library or procedure.

CREATE SEQUENCE statement

Creates a sequence that can be used to generate primary key values that are unique across multiple tables, and for generating default values for a table.

CREATE SERVER statement

Creates a remote server or a directory access server.

CREATE SERVICE statement [HTTP web service]

Creates a new HTTP web service.

CREATE SERVICE statement [SOAP web service]

Creates a new SOAP over HTTP or DISH service.

CREATE SPATIAL REFERENCE SYSTEM statement

Creates or replaces a spatial reference system.

CREATE SPATIAL UNIT OF MEASURE statement

Creates or replaces a spatial unit of measurement.

CREATE STATISTICS statement

Recreates the column statistics used by the optimizer, and stores them in the ISYSCOLSTAT system table.

CREATE SUBSCRIPTION statement [SQL Remote]

Creates a subscription for a user to a publication.

CREATE SYNCHRONIZATION PROFILE statement [MobiLink]

Creates a SQL Anywhere synchronization profile.

CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Creates a subscription in a SQL Anywhere remote database between a MobiLink user and a publication.

CREATE SYNCHRONIZATION USER statement [MobiLink]

Creates a MobiLink user in a SQL Anywhere remote database.

CREATE TABLE statement

Creates a new table in the database and, optionally, creates a table on a remote server.

CREATE TEMPORARY TRACE EVENT statement

Creates a user trace event that persists until the database is stopped.

CREATE TEMPORARY TRACE EVENT SESSION statement

Creates a user trace event session.

CREATE TEXT CONFIGURATION statement

Creates a text configuration object for use with building and updating text indexes.

CREATE TEXT INDEX statement

Creates a text index.

CREATE TIME ZONE statement

Creates a time zone object that can be used by the database to simulate a time zone that is different from the server's time zone.

CREATE TRIGGER statement

Creates a trigger on a table.

CREATE TRIGGER statement [T-SQL]

Creates a new trigger in the database in a manner compatible with Adaptive Server Enterprise.

CREATE USER statement

Creates a database user or group.

CREATE VARIABLE statement

Creates a connection- or database-scope variable.

CREATE VIEW statement

Creates a view on the database.

DEALLOCATE DESCRIPTOR statement [ESQL]

Frees memory associated with a SQL descriptor area.

DEALLOCATE statement

This statement has no effect in SQL Anywhere, and is ignored. It is provided for compatibility with Adaptive Server Enterprise and Microsoft SQL Server. Refer to your Adaptive Server Enterprise or Microsoft SQL Server documentation for more information about this statement.

Declaration section [ESQL]

Declares host variables in an Embedded SQL program. Host variables are used to exchange data with the database.

DECLARE CURSOR statement [ESQL] [SP]

Declares a cursor.

DECLARE LOCAL TEMPORARY TABLE statement

Declares a local temporary table.

DECLARE statement

Declares a SQL variable (connection-scope) or an exception within a compound statement (BEGIN...END).

DELETE statement (positioned) [ESQL] [SP]

Deletes the data at the current location of a cursor.

DELETE statement

Deletes rows from the database.

DESCRIBE statement [ESQL]

Gets information about the host variables required to store data retrieved from the database, or host variables required to pass data to the database.

DESCRIBE statement [Interactive SQL]

Returns information about a given database object.

DETACH TRACING statement (deprecated)

The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. The DETACH TRACING session ends a diagnostic tracing session.

DISCONNECT statement [ESQL] [Interactive SQL]

Drops a connection to a database.

DROP CERTIFICATE statement

Drops a certificate from the database.

DROP CONNECTION statement

Drops a user's connection to the database.

DROP DATABASE statement

Deletes all database files associated with a database.

DROP DATATYPE statement

Removes a data type from the database.

DROP DBSPACE statement

Removes a dbspace from the database.

DROP DOMAIN statement

Removes a domain (data type) from the database.

DROP EVENT statement

Drops an event from the database.

DROP EXTERNLOGIN statement

Drops an external login from the database.

DROP FUNCTION statement

Removes a function from the database.

DROP INDEX statement

Removes an index from the database.

DROP LDAP SERVER statement

Drops an LDAP server configuration object.

DROP LOGIN POLICY statement

Drops a login policy.

DROP MATERIALIZED VIEW statement

Removes a materialized view from the database.

DROP MESSAGE statement

Removes a message from the database.

DROP MIRROR SERVER statement

Drops a mirror server.

DROP MUTEX statement

Drops the specified mutex.

DROP ODATA PRODUCER statement

Drops an OData Producer.

DROP PROCEDURE statement

Removes a procedure from the database.

DROP PUBLICATION statement [MobiLink] [SQL Remote]

Drops a publication.

DROP REMOTE MESSAGE TYPE statement [SQL Remote]

Deletes a message type definition from a database.

DROP REMOTE CONNECTION statement

Drops remote data access connections to a remote server.

DROP ROLE statement

Removes a role from the database, or converts a user-extended role back to a regular user.

DROP SEMAPHORE statement

Drops a semaphore.

DROP SEQUENCE statement

Drops a sequence.

DROP SERVER statement

Drops a remote server from the catalog.

DROP SERVICE statement

Drops a web service.

DROP SPATIAL REFERENCE SYSTEM statement

Drops a spatial reference system.

DROP SPATIAL UNIT OF MEASURE statement

Drops a spatial unit of measurement.

DROP STATEMENT statement [ESQL]

Frees statement resources.

DROP STATISTICS statement

Erases all column statistics on the specified columns.

DROP SUBSCRIPTION statement [SQL Remote]

Drops a subscription for a user from a publication.

DROP SYNCHRONIZATION PROFILE statement [MobiLink]

Deletes a SQL Anywhere synchronization profile.

DROP SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

Drops a synchronization subscription in a remote database.

DROP SYNCHRONIZATION USER statement [MobiLink]

Drops one or more synchronization users from a SQL Anywhere remote database.

DROP TABLE statement

Removes a table from the database.

DROP TEXT CONFIGURATION statement

Drops a text configuration object.

DROP TEXT INDEX statement

Removes a text index from the database.

DROP TIME ZONE statement

Drops a time zone from the database.

DROP TRACE EVENT statement

Drops a user-defined trace event.

DROP TRACE EVENT SESSION statement

Drops a trace event session.

DROP TRIGGER statement

Removes a trigger from the database.

DROP USER statement

Drops a user.

DROP VARIABLE statement

Drops a SQL variable.

DROP VIEW statement

Removes a view from the database.

EXCEPT statement

Returns the set difference of two query blocks.

EXECUTE IMMEDIATE statement [SP]

Enables dynamically constructed statements to be executed from within a procedure.

EXECUTE statement [ESQL]

Executes a prepared SQL statement.

EXECUTE statement [T-SQL]

Invokes a procedure (an Adaptive Server Enterprise-compatible alternative to the CALL statement), executes a prepared SQL statement in Transact-SQL.

EXIT statement [Interactive SQL]

Leaves Interactive SQL.

EXPLAIN statement [ESQL]

Retrieves a text specification of the optimization strategy used for a particular cursor.

FETCH statement [ESQL] [SP]

Positions, or re-positions, a cursor to a specific row, and then copies expression values from that row into variables accessible from within the stored procedure or application.

FOR statement

Repeats the execution of a statement list once for each row in a cursor.

FORWARD TO statement

Sends native syntax SQL statements to a remote server.

FROM clause

Specifies the database tables or views involved in a DELETE, SELECT, or UPDATE statement. When used within a SELECT statement, the FROM clause can also be used in a MERGE or INSERT statement.

GET DATA statement [ESQL]

Gets string or binary data for one column of the current row of a cursor.

GET DESCRIPTOR statement [ESQL]

Retrieves information about a variable within a descriptor area, or retrieves its value.

GET OPTION statement [ESQL]

Gets the current setting of an option. It is recommended that you use the CONNECTION_PROPERTY function instead.

GOTO statement

Branches to a labeled statement.

GRANT statement

Grant system and object-level privileges to users and roles.

GRANT ROLE statement

Grant roles to users and roles.

GRANT CONNECT statement

Creates a new user, and can also be used by a user to change their own password. However, it is recommended that you use the CREATE USER statement to create users instead of the GRANT CONNECT statement.

GRANT CONSOLIDATE statement [SQL Remote]

Identifies the database immediately above the current database in a SQL Remote hierarchy, that will receive messages from the current database.

GRANT CREATE statement

Allows a user to create database objects in the specified dbspace.

GRANT EXECUTE statement

Grants a user privilege to execute a procedure or user-defined function.

GRANT INTEGRATED LOGIN statement

Grants a user privilege to execute a procedure or user-defined function.

GRANT KERBEROS LOGIN statement

Creates a Kerberos authenticated login mapping from one or more Kerberos principals to an existing database user ID.

GRANT PUBLISH statement [SQL Remote]

Grants publisher rights to a user ID. You must have the SYS_REPLICATION_ADMIN_ROLE system role to grant publisher rights.

GRANT REMOTE statement [SQL Remote]

Identifies a database immediately below the current database in a SQL Remote hierarchy, that will receive messages from the current database. These are called remote users.

GRANT USAGE ON SEQUENCE statement

Grants privilege to use a specified sequence.

GROUP BY clause

Groups columns, alias names, and functions as part of the SELECT statement.

HELP statement [Interactive SQL]

Provides help in the Interactive SQL environment.

IF statement

Controls conditional execution of SQL statements.

IF statement [T-SQL]

Controls conditional execution of a SQL statement, as an alternative to the Watcom SQL IF statement.

INCLUDE statement [ESQL]

Includes a file into a source program to be scanned by the SQL preprocessor.

INPUT statement [Interactive SQL]

Imports data into a database table from an external file, from the keyboard, from an ODBC data source, or from a shapefile.

INSERT statement

Inserts a single row or a selection of rows from elsewhere in the database into a table.

INSTALL EXTERNAL OBJECT statement

Installs an object that can be run in an external environment.

INSTALL JAVA statement

Makes Java classes available for use within a database.

INTERSECT statement

Computes the intersection between the result sets of two or more queries.

LEAVE statement

Leaves a compound statement or loop.

LOAD STATISTICS statement

Intended for internal use, this statement is used by the dbunload utility to unload column statistics from the old database into the ISYSCOLSTAT system table.

LOAD TABLE statement

Imports bulk data into a database table from an external file.

LOCK FEATURE statement

Prevents other concurrent connections from using a database server feature.

LOCK MUTEX statement

Locks a resource such as a file or system procedure using a predefined mutex.

LOCK TABLE statement

Prevents other concurrent transactions from accessing or modifying a table.

LOOP statement

Repeats the execution of a statement list.

MERGE statement

Merges tables, views, and procedure results into a table or view.

MESSAGE statement

Displays a message.

NOTIFY SEMAPHORE statement

Increments the counter associated with a semaphore.

NOTIFY TRACE EVENT statement

Logs a user-defined trace event to a trace session.

OPEN statement [ESQL] [SP]

Opens a previously declared cursor to access information from the database.

OUTPUT statement [Interactive SQL]

Outputs the current query results to a file.

PARAMETERS statement [Interactive SQL]

Specifies parameters to an Interactive SQL script file.

PASSTHROUGH statement [SQL Remote]

Starts or stops passthrough mode for SQL Remote administration.

PIVOT clause

Pivots a table expression in the FROM clause of a SELECT statement (FROM pivoted-derived-table) into a pivoted derived table. Pivoted derived tables offer an easy way to rotate row values from a column in a table expression into multiple columns and perform aggregation where needed on the columns included in the result set.

PREPARE statement [ESQL]

Prepares a statement to be executed later, or defines a cursor.

PREPARE TO COMMIT statement

Checks whether a COMMIT can be performed successfully.

PRINT statement [T-SQL]

Returns a message to the client, or display a message in the database server messages window.

PUT statement [ESQL]

Inserts a row into the specified cursor.

RAISERROR statement

Signals an error and sends a message to the client.

READ statement [Interactive SQL]

Reads Interactive SQL statements from a file.

READTEXT statement [T-SQL]

Reads text and image values from the database, starting from a specified offset and reading a specified number of bytes. This feature is provided solely for compatibility with Transact-SQL and its use is not recommended.

REFRESH MATERIALIZED VIEW statement

Initializes or refreshes the data in a materialized view by executing its query definition.

REFRESH TEXT INDEX statement

Refreshes a text index.

REFRESH TRACING LEVEL statement (deprecated)

The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. The REFRESH TRACING LEVEL statement reloads the tracing levels from the sa_diagnostic_tracing_level table while a tracing session is in progress.

RELEASE MUTEX statement

Releases the specified connection-scope mutex, if it is locked by the current connection.

RELEASE SAVEPOINT statement

Releases a savepoint within the current transaction.

REMOTE RESET statement [SQL Remote]

Starts all subscriptions for a remote user in a single transaction in custom database-extraction procedures.

REMOVE EXTERNAL OBJECT statement

Removes an external object from the database.

REMOVE JAVA statement

Removes a class or JAR file from a database.

REORGANIZE TABLE statement

Defragments tables when a full rebuild of the database is not possible due to the requirements for continuous access to the database.

RESIGNAL statement [SP]

Resignals an exception condition.

RESTORE DATABASE statement

Restores a backed up database from an archive.

RESUME statement

Resumes execution of a cursor that returns result sets.

RETURN statement

Exits from a function, procedure, or batch unconditionally, optionally providing a return value.

REVOKE CONSOLIDATE statement [SQL Remote]

Stops a consolidated database from receiving SQL Remote messages from this database.

REVOKE PUBLISH statement [SQL Remote]

Terminates the identification of the named user ID as the current publisher. You must have the SYS_REPLICATION_ADMIN_ROLE system role to revoke publisher rights.

REVOKE REMOTE statement [SQL Remote]

Stops a user from being able to receive SQL Remote messages from this database.

REVOKE statement

Revokes system and object-level privileges from users and roles.

REVOKE ROLE statement

Revokes roles and privileges from users and roles.

ROLLBACK statement

Ends a transaction and undo any changes made since the last COMMIT or ROLLBACK.

ROLLBACK TO SAVEPOINT statement

Cancels any changes made since a SAVEPOINT.

ROLLBACK TRANSACTION statement [T-SQL]

Cancels any changes made since a SAVE TRANSACTION.

ROLLBACK TRIGGER statement

Undoes any changes made in a trigger.

SAVE TRANSACTION statement [T-SQL]

Establishes a savepoint within the current transaction.

SAVEPOINT statement

Establishes a savepoint within the current transaction.

SELECT statement

Retrieves information from the database.

SET CONNECTION statement [Interactive SQL] [ESQL]

Changes the active database connection.

SET DESCRIPTOR statement [ESQL]

Describes the variables in a SQL descriptor area and to place data into the descriptor area.

SET MIRROR OPTION statement

Changes the values of options that control the settings for database mirroring and read-only scale-out.

SET OPTION statement

Changes the values of database and connection options.

SET OPTION statement [Interactive SQL]

Changes the values of Interactive SQL options.

SET REMOTE OPTION statement [SQL Remote]

Sets a message control parameter for a SQL Remote message link.

SET SQLCA statement [ESQL]

Instructs the SQL preprocessor to use a SQLCA other than the default, global sqlca.

SET statement

Assigns a value to a SQL variable.

SET statement [T-SQL]

Sets database options for the current connection in an Adaptive Server Enterprise-compatible manner.

SETUSER statement

Allows a user to assume the identity of (impersonate) another authorized user.

SIGNAL statement [SP]

Signals an exception condition.

START DATABASE statement

Starts a database on the current database server.

START SERVER statement [Interactive SQL]

Starts a database server.

START EXTERNAL ENVIRONMENT statement

Starts an external environment.

START JAVA statement

Starts the Java VM.

START LOGGING statement [Interactive SQL]

Starts logging executed SQL statements and messages to a log file.

START SUBSCRIPTION statement [SQL Remote]

Starts a subscription for a user to a publication.

START SYNCHRONIZATION DELETE statement [MobiLink]

Restarts logging of deletes for MobiLink synchronization.

START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]

Starts a MobiLink synchronization schema change.

STOP DATABASE statement

Stops a database on the current database server.

STOP EXTERNAL ENVIRONMENT statement

Stops an external environment.

STOP JAVA statement

Stops the Java VM.

STOP LOGGING statement [Interactive SQL]

Stops logging of SQL statements and messages for the current session.

STOP SERVER statement

Stops a database server.

STOP SUBSCRIPTION statement [SQL Remote]

Stops a subscription for a user to a publication.

STOP SYNCHRONIZATION DELETE statement [MobiLink]

Temporarily stops logging of deletes for MobiLink synchronization.

STOP SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]

Stops a MobiLink synchronization schema change.

SYNCHRONIZE statement [MobiLink]

Synchronizes a SQL Anywhere database with a MobiLink server. The synchronization options can be specified in the statement itself.

SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]

Synchronizes a subscription for a user to a publication.

SYSTEM statement [Interactive SQL]

Launches an executable file from within Interactive SQL.

TRIGGER EVENT statement

Triggers a named event. The event may be defined for event triggers or be a scheduled event.

TRUNCATE statement

Deletes all rows from a table without deleting the table definition.

TRUNCATE TEXT INDEX statement

Deletes the data in a MANUAL or an AUTO REFRESH text index.

TRY statement

Implements error handling for compound statements (if an error occurs in the TRY block, it passes control to another group of statements that is enclosed in a CATCH block).

UNION statement

Combines the results of two or more SELECT statements or query expressions.

UNLOAD statement

Unloads data from a data source into a file.

UNPIVOT clause

Unpivots compatible-type columns of a table expression in a FROM clause (FROM unpivoted-derived-table expression) into rows in a derived table. Unpivoting is used to normalize data, for example when you have similar data stored in multiple columns in tables and you want to return it in one column.

UPDATE (positioned) statement [ESQL] [SP]

Modifies the data at the current location of a cursor.

UPDATE statement [SQL Remote]

Modifies data in the database.

UPDATE statement

Modifies rows in database tables.

VALIDATE LDAP SERVER statement

Validates an LDAP server configuration object.

VALIDATE statement

Validates the current database, one or more tables, materialized views, or indexes in the current database.

WAITFOR statement

Delays processing for the current connection for a specified amount of time or until a given time.

WAITFOR SEMAPHORE statement

Decrements the counter associated with a semaphore.

WHENEVER statement [ESQL]

Specifies error handling in Embedded SQL programs.

WHILE statement [T-SQL]

Provides repeated execution of a statement or compound statement.

WINDOW clause

Defines all or part of a window for use with window functions such as AVG and RANK in a SELECT statement.

WRITETEXT statement [T-SQL]

Permits non-logged updating of a CHAR, NCHAR, or BINARY column. This feature is provided solely for compatibility with Transact-SQL and its use is not recommended.