ALTER SCHEMA Statement

Enables you to change the name of a schema. You can also alter advanced options that are driver–specific.

ALTER SCHEMA [ "catalog"."schema" ]  RENAME TO "newschema"

ALTER SCHEMA [ "catalog"."schema" ] AUTHORIZATION|OWNER TO owner

[ create-if option ]

ALTER SCHEMA [ "catalog"."schema" ]

[ alter-schema-options ]

“catalog”

Specifies the catalog name.

“schema”

Specifies the schema name.

“newschema”

Specifies the new schema name.

alter-schema-options

Specifies what options to alter in the schema.

 alter-schema-options ::=

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

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

alter-schema-option

Specifies the schema option to alter. This option only applies to the BASE data service.

 alter-schema-option ::=

[DROP schema-option-name ]
     [{ADD | SET} schema-option ]
       [create-if-option

schema-option

Specifies the syntax for schema options.

conopts-configuration-list

If DRIVERdriver-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 DRIVER driver-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 applies to BASE schemas only and is required.

path ::= quoted-identifier

quoted-identifier

Specifies a single quoted or double quoted name.

create-if-option

Creates the schema if it does not already exist using the remaining options.

create-if-option
CREATE_IF N[O]|F[ALSE]|OFF|0|Y[ES]|T[RUE]|ON|1

Examples:

ALTER SCHEMA "catalog1_BASE"."schema3_BASE" RENAME TO "schema3_BASE_RENAME"

ALTER SCHEMA "catalog1_BASE"."schema3_BASE" {OPTIONS set primarypath 'C:\mydir'}

ALTER SCHEMA "catalog1_BASE"."schema3_BASE" {OPTIONS add conopts (LOCKTABLE SHARE)}