CREATE statements

Use the CREATE statements to create functions, indexes, procedures, roles, schemas, synonyms, tables, triggers, and views.

• CREATE DERBY AGGREGATE statement
  The CREATE DERBY AGGREGATE statement creates a user-defined aggregate (UDA). A UDA is a custom aggregate operator.
• CREATE FUNCTION statement
  The CREATE FUNCTION statement creates a Java function, which you can then use in an expression.
• CREATE INDEX statement
  A CREATE INDEX statement creates an index on a table. Indexes can be on one or more columns in the table.
• CREATE PROCEDURE statement
  The CREATE PROCEDURE statement creates a Java stored procedure, which you can then call using the CALL PROCEDURE statement.
• CREATE ROLE statement
  The CREATE ROLE statement creates an SQL role. Roles are useful for administering privileges when a database has many users.
• CREATE SCHEMA statement
  The CREATE SCHEMA statement creates a schema, which is a way to logically group objects in a single collection and to provide a unique namespace for objects.
• CREATE SEQUENCE statement
  The CREATE SEQUENCE statement creates a sequence generator, which is a mechanism for generating exact numeric values, one at a time.
• CREATE SYNONYM statement
  The CREATE SYNONYM statement provides an alternate name for a table or a view that is present in the same schema or another schema.
• CREATE TABLE statement
  The CREATE TABLE statement creates a table. Tables contain columns and constraints, rules to which data must conform.
• CREATE TRIGGER statement
  The CREATE TRIGGER statement creates a trigger, which defines a set of actions that are executed when a database event occurs on a specified table.
• CREATE TYPE statement
  The CREATE TYPE statement creates a user-defined type (UDT). A UDT is a serializable Java class whose instances are stored in columns.
• CREATE VIEW statement
  The CREATE VIEW statement creates a view, which is a virtual table formed by a query.