Creates (registers) a new external module.

Syntax

---

CREATE MODULE <Name>
PATH <ExternalModuleFile>
[DESCRIPTION <Description>]

<ExternalModuleFile> = Path/file name of DLL

Usage

---

Use this statement to create (register) a new external module. An external module is a compiled DLL that contains specific code that can be used as a text filter, word generator, migrator, or external procedure/function. Please see the External Modules topic for more information.

Examples

---

-- The following statement registers a
-- text filter external module

CREATE MODULE "TextFilterModule"
PATH 'c:\myapplication\modules\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: