ASSEMBLYPROPERTY (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about a property of an assembly.

Topic link icon Transact-SQL Syntax Conventions

Syntax

ASSEMBLYPROPERTY('assembly_name', 'property_name')  

Arguments

assembly_name
Is the name of the assembly.

property_name
Is the name of a property about which to retrieve information. property_name can be 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

The following example assumes a HelloWorld assembly is registered in the AdventureWorks2012 database. For more information, see Hello World Sample.

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

See also

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