DROP EXTERNAL LANGUAGE (Transact-SQL)
Applies to:
SQL Server 2019 (15.x)
Deletes an existing external language.
Syntax
DROP EXTERNAL LANGUAGE <language_name>
Arguments
language_name
Languages are database scoped objects. Language names must be unique within the database.
Permissions
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.
Return values
An informational message is returned if the statement was successful.
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Remarks
Before an external language can be deleted, all external libraries for the specified language need to be deleted.
Examples
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;
See also
CREATE EXTERNAL LANGUAGE (Transact-SQL)
ALTER EXTERNAL LANGUAGE (Transact-SQL)
sys.external_languages
sys.external_language_files
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin