| title | ASSEMBLYPROPERTY (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 07/24/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | cf03d1b1-724c-48bf-a8df-3fe2586b150a | ||
| caps.latest.revision | 40 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Returns information about a property of an assembly.
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 [!INCLUDEssSampleDBobject] database. For more information, see Hello World Sample.
USE AdventureWorks2012;
GO
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');