ASSEMBLYPROPERTY (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

This function returns information about a property of an assembly.

Syntax

syntaxsql

ASSEMBLYPROPERTY('assembly_name', 'property_name')

assembly_name
The name of the assembly.

property_name
The name of a property about which to retrieve information. property_name can have one of the following values:

Value	Description
CultureInfo	Locale of the assembly.
PublicKey	Public key or public key token of the assembly.
MvID	Complete, compiler-generated version identification number of the assembly.
VersionMajor	Major component (first part) of the four-part version identification number of the assembly.
VersionMinor	Minor component (second part) of the four-part version identification number of the assembly.
VersionBuild	Build component (third part) of the four-part version identification number of the assembly.
VersionRevision	Revision component (fourth part) of the four-part version identification number of the assembly.
SimpleName	Simple name of the assembly.
Architecture	Processor architecture of the assembly.
CLRName	Canonical string that encodes the simple name, version number, culture, public key, and architecture of the assembly. This value uniquely identifies the assembly on the common language runtime (CLR) side.

sql_variant

This example assumes a HelloWorld assembly that is registered in the AdventureWorks2022 database. For more information, see Hello World Sample.

SQL

USE AdventureWorks2022;  
GO  
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');