ASSEMBLYPROPERTY (Transact-SQL)

ASSEMBLYPROPERTY (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

ValueDescription
CultureInfoLocale of the assembly.
PublicKeyPublic key or public key token of the assembly.
MvIDComplete, compiler-generated version identification number of the assembly.
VersionMajorMajor component (first part) of the four-part version identification number of the assembly.
VersionMinorMinor component (second part) of the four-part version identification number of the assembly.
VersionBuildBuild component (third part) of the four-part version identification number of the assembly.
VersionRevisionRevision component (fourth part) of the four-part version identification number of the assembly.
SimpleNameSimple name of the assembly.
ArchitectureProcessor architecture of the assembly.
CLRNameCanonical 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');  

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

Community Additions

ADD
Show:
© 2016 Microsoft