ASSEMBLYPROPERTY (Transact-SQL)

Returns information about a property of an assembly.

Topic link iconTransact-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 that the SQL Server Database Engine samples are installed on the local computer and the HelloWorld assembly is registered in the AdventureWorks2008R2 database. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

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