Icon ALTER MODULE

Alters an existing external module.

Syntax
ALTER MODULE <Name>
PATH <ExternalModuleFile>
[DESCRIPTION <Description>]

<ExternalModuleFile> = Path/file name of DLL

Usage
Use this statement to alter an existing external module.

Information All clauses after the PATH clause are optional. If they are not specified, then they will not be altered and will stay the same as before the ALTER MODULE statement was executed.

Examples
-- The following statement changes the path
-- of the TextFilterModule module

ALTER MODULE "TextFilterModule"
PATH 'c:\myapplication\dlls\txtfilter.dll'
DESCRIPTION 'Text Filter Module'

Required Privileges
The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
ExtensionThis SQL statement is an ElevateDB extension
Image