Skip to content

drop-external-language-transact-sql.md

Latest commit

 

History

History
66 lines (46 loc) · 1.86 KB

drop-external-language-transact-sql.md

File metadata and controls

66 lines (46 loc) · 1.86 KB
title ALTER EXTERNAL LANGUAGE (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 05/16/2019
ms.prod sql
ms.technology t-sql
ms.topic language-reference
author nelgson
ms.author negust
ms.reviewer dphansen
manager cgronlun
monikerRange >=sql-server-ver15||=sqlallproducts-allversions

DROP EXTERNAL LIBRARY (Transact-SQL)

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx]

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, and delete it using the DROP EXTERNAL LANGUAGE statement.

CREATE EXTERNAL LANGUAGE Java 
FROM (CONTENT = N'<path-to-zip>', FILE_NAME = 'javaextension.dll');
GO
DROP EXTERNAL LANGUAGE Java;

See also

CREATE EXTERNAL LANGUAGE (Transact-SQL)
ALTER EXTERNAL LANGUAGE (Transact-SQL)
sys.external_languages
sys.external_language_files