Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram>>-CREATE SCHEMA--+-schema-name-----------------------+--------->
                  '-AUTHORIZATION--authorization-name-'
 
>--+----------------------+------------------------------------->
   '-IN ASP--+-integer--+-'
             '-ASP-name-'
 
>--+----------------------------------------------------+------><
   | .------------------------------------------------. |
   | V                                                | |
   '---+-COMMENT statement--------------------------+-+-'
       +-CREATE ALIAS statement---------------------+
       +-CREATE DISTINCT TYPE statement-------------+
       +-CREATE INDEX statement---------------------+
       +-CREATE SEQUENCE statement------------------+
       +-CREATE TABLE statement---------------------+
       +-CREATE VIEW statement----------------------+
       +-GRANT (Distinct Type Privileges) statement-+
       +-GRANT (Sequence Privileges) statement------+
       +-GRANT (Table Privileges) statement---------+
       |                 (1)                        |
       '-LABEL statement----------------------------'
 
Notes:
  1. Labels and comments on packages, procedures, functions, and parameters are not supported in the CREATE SCHEMA statement.