Export (0) Print
Expand All
Expand Minimize

ASSEMBLYPROPERTY (Transact-SQL)

Returns information about a property of an assembly.

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

Community Additions

ADD
Show:
© 2014 Microsoft