ASSEMBLYPROPERTY (Transact-SQL)

Applies to: SQL Server Azure SQL Managed Instance

This function returns information about a property of an assembly.

Transact-SQL syntax conventions

Syntax

ASSEMBLYPROPERTY('assembly_name', 'property_name')  

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Arguments

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.

Return type

sql_variant

Examples

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

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

See also

CREATE ASSEMBLY (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)