ALTER DATABASE Statement
Upgrades a database created with a previous version of the software, adds or removes jConnect™ for JDBC™ support, or defines management of system procedure execution. Run this statement with DBISQL Interactive SQL.
ALTER DBSPACE Statement
Changes the read/write mode, changes the size, or extends an existing dbspace.
ALTER DOMAIN Statement
Renames a user-defined domain or data type. Does not rename Java types.
ALTER EVENT Statement
Changes the definition of an event or its associated handler for automating predefined actions. Also alters the definition of scheduled actions.
ALTER FUNCTION Statement
Modifies an existing function. Include the entire modified function in the ALTER FUNCTION statement.
ALTER INDEX Statement
Renames indexes in base or global temporary tables, foreign key role names of indexes and foreign keys explicitly created by a user, or changes the clustered nature of an index on a catalog store table.
ALTER LDAP SERVER Statement
Any changes to an LDAP server configuration object are applied on subsequent connections. Any connection already started when the change is applied does not immediately reflect the change.
ALTER PROCEDURE Statement
Replaces an existing procedure with a modified version. Include the entire modified procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.
ALTER ROLE Statement
Migrates a compatibility role to a user-defined system role, then automatically drops the compatibility role.
ALTER SEQUENCE statement
Alters a sequence. This statement applies to SAP Sybase IQ catalog store tables only.
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 TRIGGER statement
Replaces a trigger definition with a modified version. You must include the entire new trigger definition in the ALTER TRIGGER statement.
CREATE LDAP SERVER Statement
Creates a new LDAP server configuration object for LDAP user authentication. Parameters defined during the creation of an LDAP server configuration object are stored in the ISYSLDAPSERVER (system view SYSLDAPSERVER) system table.
CREATE ROLE Statement
Creates a new role, extends an existing user to act as a role, or manages role administrators on a role.
CREATE SCHEMA Statement
Creates a schema, which is a collection of tables, views, and permissions and their associated permissions, for a database user.
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. This statement applies to SAP Sybase IQ catalog store tables only.
CREATE VIEW Statement
Creates a view on the database. Views are used to give a different perspective on the data even though it is not stored that way.
DESCRIBE Statement [ESQL]
Gets information about the host variables required to store data retrieved from the database or host variables used to pass data to the database.
DROP LDAP SERVER Statement
Removes the named LDAP server configuration object from the SYSLDAPSERVER system view after verifying that the LDAP server configuration object is not in a READY or ACTIVE state.
FOR Statement
Repeats the execution of a statement list once for each row in a cursor.
FOR JSON Statement
You can execute a SQL query against your database and return the results as a JSON document by using the FOR JSON clause in a SELECT statement.
FROM Clause
Specifies the database tables or views involved in a SELECT statement.
GET DESCRIPTOR Statement [ESQL]
Retrieves information about variables within a descriptor area, or retrieves actual data from a variable in a descriptor area.
IF Statement
Provides conditional execution of SQL statements.
IF Statement [T-SQL]
Provides conditional execution of a Transact-SQL statement, as an alternative to the SAP Sybase IQ IF statement.
INCLUDE Statement [ESQL]
Includes a file into a source program to be scanned by the SQL source language preprocessor.
INSERT Statement
Inserts a single row or a selection of rows, from elsewhere in the current database, into the table. This command can also insert a selection of rows from another database into the table.
SET SQLCA Statement [ESQL]
Tells the SQL preprocessor to use a SQLCA other than the default global sqlca.
SETUSER Statement
Allows a user to temporarily assume the roles and system privileges of another user (also known as impersonation) to perform operations, provided they already have the minimum required privileges to perform the task to begin with.