SQL Statements
Lists the SQL statements that relate to in-memory row-level versioning.
ALTER DBSPACE Statement
Changes the read/write mode, changes the size, or extends an existing dbspace.
ALTER TABLE Statement
Modifies a table definition.
CREATE DBSPACE Statement
Creates a new dbspace and the associated dbfiles for the IQ main store, catalog store, or RLV store.
CREATE TABLE Statement
Creates a new table in the database or on a remote server.
DELETE Statement
Deletes rows from the database.
DROP Statement
Removes objects from the database.
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.
LOAD TABLE Statement
Imports data into a database table from an external file.
LOCK TABLE Statement
Prevents other concurrent transactions from accessing or modifying a table within the specified time.
TRUNCATE Statement
Deletes all rows from a table or materialized view without deleting the table definition.
UPDATE Statement
Modifies existing rows of a single table, or a view that contains only one table.
Parent topic:
Appendix: SQL Reference
Created May 23, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com