Class ObjectSchema.ExternalLibrary

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.external_libraries (Transact-SQL)

Applies to: √ SQL Server 2017 (14.x) and later √ Azure SQL Managed Instance

Supports the management of package libraries related to external runtimes such as R, Python, and Java.

note

In SQL Server 2017, R language and Windows platform are supported. R, Python, and Java on the Windows and Linux platforms are supported in SQL Server 2019 and later. On Azure SQL Managed Instance, R and Python are supported.

## sys.external_libraries
The catalog view sys.external_libraries lists a row for each external library that has been uploaded into the database.

See sys.external_libraries.

[Table(Schema = "sys", Name = "external_libraries", IsView = true)]
public class ObjectSchema.ExternalLibrary

Inheritance

object

ObjectSchema.ExternalLibrary

Extension Methods

Map.DeepCopy<T>(T)

Properties

ExternalLibraryID

ID of the external library object.

[Column("external_library_id")]
[NotNull]
public object ExternalLibraryID { get; set; }

Property Value

object

Language

Name of the language or runtime that supports the external library. Valid values are 'R', 'Python', and 'Java'. Additional runtimes might be added in future.

[Column("language")]
[Nullable]
public object? Language { get; set; }

Property Value

object

Name

Name of the external library. Is unique within the database per owner.

[Column("name")]
[Nullable]
public object? Name { get; set; }

Property Value

object

PrincipalID

ID of the principal that owns this external library.

[Column("principal_id")]
[Nullable]
public object? PrincipalID { get; set; }

Property Value

object

Scope

0 for public scope; 1 for private scope

[Column("scope")]
[NotNull]
public object Scope { get; set; }

Property Value

object

ScopeDesc

Indicates whether the package is public or private

[Column("scope_desc")]
[NotNull]
public string ScopeDesc { get; set; }

Property Value

string