ASSEMBLYPROPERTY (Transact-SQL)
Returns information about a property of an assembly.
.gif "Topic link icon")
Transact-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 a HelloWorld assembly is registered in the AdventureWorks2012 database. For more information, see Hello World Sample.
USE AdventureWorks2012;
GO
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');