Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server 2019 (15.x)
Deletes an existing external language.
DROP EXTERNAL LANGUAGE <language_name>
language_name
Languages are database scoped objects. Language names must be unique within the database.
To delete a language requires the privilege ALTER ANY EXTERNAL LANGUAGE. By default, any database owner, or the owner of the object, can also delete an external language.
Note
Note that before removing an external language, you need to remove the external libraries referencing the external language.
An informational message is returned if the statement was successful.
Before an external language can be deleted, all external libraries for the specified language need to be deleted.
Create an external language Java:
CREATE EXTERNAL LANGUAGE Java
FROM (CONTENT = N'<path-to-zip>', FILE_NAME = 'javaextension.dll');
GO
Drop the external language:
DROP EXTERNAL LANGUAGE Java;
CREATE EXTERNAL LANGUAGE (Transact-SQL)
ALTER EXTERNAL LANGUAGE (Transact-SQL)
sys.external_languages
sys.external_language_files
Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!