# 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.

Parent topic: Statements