Quick start guide to schema operations and data management

Create, update, or retrieve tables, indexes, foreign keys, publications, and rows in your database using SQL statements and queries.

Some SQL statements are not supported for BlackBerry smartphones.

When performing schema operations to manage data, you typically perform the following tasks in your application code:

Perform schema operations.

Manage and modify the schema by using SQL statements such as CREATE TABLE or CREATE INDEX on the database connection.
Manage row operations.

Manage data in tables using SQL statements such as INSERT, UPDATE, or DELETE on the database connection.
Retrieve row data in a result set.

Retrieve a result set using the SELECT statement, and then traverse the row data using result set navigation methods, such as previous and next.

Discuss this page in DocCommentXchange.