ASSEMBLYPROPERTY

Returns information about a property of an assembly.

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.

Return types

sql_variant

Example

select ASSEMBLYPROPERTY('random_assembly_name', 'CultureInfo');

See Also