drop-external-language-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
DROP EXTERNAL LANGUAGE (Transact-SQL) - SQL Server	DROP EXTERNAL LANGUAGE (Transact-SQL) - SQL Server	MikeRayMSFT	mikeray	rothja	08/08/2019	sql	language-extensions	reference	TSQL	>=sql-server-ver15||>=sql-server-linux-ver15

DROP EXTERNAL LANGUAGE (Transact-SQL)

[!INCLUDE SQL Server 2019 and later]

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.

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