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.

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 AdventureWorks database. For more information, see Hello World Sample.

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

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance