sa_column_stats system procedure
Returns various statistics about the specified column(s). These statistics are not related to the column statistics maintained for use by the optimizer.
sa_get_bits system procedure
Takes a bit string and returns a row for each bit in the string. By default, only rows with a bit value of 1 are returned.
sa_get_table_definition system procedure
Returns a LONG VARCHAR string containing the SQL statements required to create the specified table and its indexes, foreign keys, triggers, and granted privileges.
sa_http_php_page system procedure
Returns the result of passing the PHP code that is to be interpreted through a PHP interpreter using the current HTTP request for context information such as headers, GET/POST data, protocol version, request URL, method, and so on.
sa_http_php_page_interpreted system procedure
Returns the result of passing the PHP code that is to be interpreted through a PHP interpreter using the specified parameters for context information such as headers, GET/POST data, protocol version, request URL, method, and so on.
sa_mirror_server_status system procedure
Returns the connection status of the current servers and all the servers that are directly or indirectly receiving log pages from the current server. On primary servers, the procedure returns the status of all connected servers.
sa_procedure_profile system procedure
Reports information about the execution time for each line within procedures, functions, events, or triggers that have been executed in a database.
sa_remove_tracing_data system procedure (deprecated)
The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. The sa_remove_tracing_data system procedure permanently deletes from the diagnostic tracing tables all records pertaining to the specified logging (tracing) session ID.
sa_reset_identity system procedure
Allows the next identity value to be set for a table. Use this procedure to change the AUTOINCREMENT value for the next row that will be inserted.
sa_set_tracing_level system procedure (deprecated)
The diagnostic tracing feature is deprecated. Use the SQL Anywhere Profiler to diagnose issues in your database. Initializes the level of tracing information to be stored in the diagnostic tracing tables.
sa_statement_text system procedure
Formats a SELECT statement so that individual items appear on separate lines. This is useful when viewing long statements from the request log, in which all newline characters are removed.
sp_displayroles system procedure
Returns all roles granted to the specified system privilege, system role, user-defined role, or user name, or displays the entire hierarchy tree of roles.
sp_has_role system procedure
Returns whether the invoker of the procedure has been granted the specified system
privilege or user-defined role.
sp_list_mutexes_semaphores system procedure
Returns information about all temporary and permanent mutexes and semaphores, including which connection is holding each mutex and whether a semaphore is being waited for.
sp_objectpermission system procedure
Generates a report on object privileges granted to a specified role or user ID, or a report on object privileges granted on a specified object or dbspace.
sp_plancache_contents system procedure
Returns the contents of a plan cache for a connection, including statistics indicating
the average, minimum, and maximum execution times, and the number of times cursors have been
built for a statement.
xp_sendmail system procedure
Sends an email message to the specified recipients once a session has been started with xp_startmail or xp_startsmtp. The procedure accepts messages of any length.