CREATE SCHEMA Statement

Use the CREATE SCHEMA statement to create a schema and designate an owner. Here is the syntax:

CREATE SCHEMA [ "catalog"."schema"]

   [ AUTHORIZATION|OWNER owner ]

   [ create-schema-options ]

“catalog”

Specifies the optional catalog name under which to create the schema. This is useful for data services that are defined for data sources that support catalog names. For those that do not, the catalog name must be the logical catalog name which defaults to the name of the data service.

“schema”

Specifies the name of the schema.

owner

Authorization identifier of the schema owner. If the AUTHORIZATION clause is not specified, schema ownership defaults to ‘system’. However, schema ownership as ‘system’ could present problems with FedSQL views and data cache.

create-schema-options

Specifies an option list for the schema.

create-schema-options ::=

"{" OPTIONS ["("] schema-option

[ { "," schema-option } ... ] [")"] "}"

schema-option

Specifies the syntax for schema options. This option only applies to the BASE data service.

conopts-configuration-list

If DRIVER driver-name is omitted, the default driver for the data service is assumed. Associated options within the CONOPTS list are used for connections using the appropriate driver.

conopts-configuration-list ::=
CONOPTS "(" [DRIVER driver-name] [","driver-connection-string-option ...] ")"...

driver-name

Specifies the driver name.

driver-connection-string-option

Specifies the connection options that correspond to the driver which is specified in DRIVERdriver-name.

Advanced options are valid to use as driver connection string options; connection options are invalid. For more information about which advanced options are supported for each data service, see the data service reference chapter for your driver. For information specific to the data service that you are configuring, go to the section that corresponds to your data service.

PRIMARYPATH path

Specifies the physical location for the SAS library, which is a collection of one or more SAS files. For example, in directory-based operating environments, a SAS library is a group of SAS files that are stored in the same directory. This option is required for BASE schemas.

PRIMARYPATH path ::=

      quoted-identifier

quoted-identifier

Specifies a single quoted or double quoted name.

Examples:

CREATE SCHEMA "catalog1_BASE"."schema1_BASE" {OPTIONS (primarypath 
'C:\schema1_BASE')}

CREATE SCHEMA "ORACLE1"."TKTSTST1"

CREATE SCHEMA "catalog1"."schema1" {OPTIONS primarypath 'C:\my_schema', 
conopts (LOCKTABLE EXCLUSIVE)}