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.


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: