Skip to main content

Schema definitions

A SCHEMA is a container for tables, views, indices, triggers, functions and procedures.  Schema access and modification is strictly controlled using the user role and authorisation scheme.

schema:
   CREATE SCHEMA schema_name_clause
  [ DEFAULT CHARACTER SET ident ]
  [ PATH schema_name ','... ]
  [ schema_element ... ]
| DROP SCHEMA qname drop_action

schema_name_clause: ident | [ ident ] AUTHORIZATION

ident schema_element: grant | revoke | create_statement | drop_statement | alter_statement