Export (0) Print
Expand All

ASSEMBLYPROPERTY (Transact-SQL)

Returns information about a property of an assembly.

Topic link icon Transact-SQL Syntax Conventions

ASSEMBLYPROPERTY('assembly_name', 'property_name')

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.

sql_variant

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');
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft