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#