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
ALTER SCHEMA [ "catalog"."schema" ]
“catalog”
Specifies the catalog
name.
“schema”
Specifies the schema
name.
“newschema”
Specifies the new
schema name.
alter-schema-options
Specifies the options
to alter 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 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 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 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
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)}