Allows modification of an existing system, which was created with CREATE SYSTEM.

Syntax

ALTER SYSTEM systemName SET OPTIONS ( key 'value' [,...] );

Arguments

  • systemName: The name of an existing system.

  • key ‘value’: One or more key-value pairs, from the following.

    • NAME: The system name.

    • HOST: The hostname or IP for the system.

Additional Information

  • To remove a non-required value, set the value to an empty string (‘ ‘).

  • Altering a system does not impact any currently connections to the system, but is effective on any new connections initiated after the ALTER SYSTEM command executes.

  • The system type cannot be changed using ALTER SYSTEM. If it’s necessary to change the system type, drop and re-create the system.

Examples

--changing the name of a system, would be SQLSRV5 after the change
ALTER SYSTEM SQLSRV1 SET OPTIONS ( NAME 'SQLSRV5' );
--changing the name and hostname/IP of a system
ALTER SYSTEM SQLSRV1 SET OPTIONS ( NAME 'SQLSRV5', HOST '127.0.0.1' );
--changing the connection properties option
ALTER SYSTEM SQLSRV1 SET OPTIONS ( CONNECTION_PROPERTIES 'ssl=true' );
--unset the option for connection properties
ALTER SYSTEM SQLSRV1 SET OPTIONS ( CONNECTION_PROPERTIES '' );