drop-external-library-transact-sql.md

title	DROP EXTERNAL LIBRARY (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/17/2017
ms.prod	sql-server-2017
ms.reviewer
ms.suite
ms.technology	r-services
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	DROP EXTERNAL LIBRARY DROP_EXTERNAL_LIBRARY_TSQL
dev_langs	TSQL
helpviewer_keywords	DROP EXTERNAL LIBRARY
author	jeannt
ms.author	jeannt
manager	jhubbard

DROP EXTERNAL LIBRARY (Transact-SQL)

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

Deletes an existing package library.

Syntax

DROP EXTERNAL LIBRARY library_name  
[ AUTHORIZATION owner_name ];  

Arguments

library_name

Specifies the name of an existing package library.

Libraries are scoped to the user. That is, library names are considered unique within the context of a specific user or owner.

owner_name

Specifies the name of the user or role that owns the external library.

Database owners can delete libraries created by other users.

Return values

An informational message is returned if the statement was successful.

Remarks

Unlike other DROP statements in SQL Server, this statement supports specifying an optional authorization clause. This allows dbo or users in the db_owner role to drop a package library uploaded by a regular user in the database.

Examples

Add ggplot2 to a database:

CREATE EXTERNAL LIBRARY ggplot2 
FROM 'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\ggplot2.zip';

Delete the ggplot2 library.

DROP EXTERNAL LIBRARY ggplot2 <user_name>;

See also

CREATE EXTERNAL LIBRARY (Transact-SQL)
ALTER EXTERNAL LIBRARY (Transact-SQL)
sys.external_library_files
sys.external_libraries