sys-external-language-files-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.external_language_files (Transact-SQL) - SQL Server	sys.external_language_files (Transact-SQL) - SQL Server	MikeRayMSFT	mikeray	rothja	05/22/2019	sql	system-objects	reference	external_languages external_languages_TSQL sys.external_languages sys.external_languages_TSQL	sys.external_languages catalog view	TSQL	>=sql-server-ver15

sys.external_language_files (Transact-SQL)

[!INCLUDESQL Server 2019 Azure SQL Managed Instance]

This catalog view provides a list of the external language extension files in the database. R and Python are reserved names and no external language can be created with those specific names.

When an external language is created from a file_spec, the extension itself and its properties are listed in this view. This view will contain one entry per language, per OS.

sys.external_language_files

The catalog view sys.external_language_files lists a row for each external language extension in the database. Parameters

Column name	Data type	Description
external_language_id	int	ID of the external language
content	varbinary(max)	Content of the external language extension file
file_name	sysname	Name of the language extension file
platform	tinyint	ID of the host platform on which SQL Server is installed
platform_desc	nvarchar(60)	Name of the host platform. Valid values are WINDOWS, LINUX.
parameters	sysname	External language parameters
environment_variables	sysname	External language environment variables

See also

• sys.external_languages
• CREATE EXTERNAL LANGUAGE