| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ASSEMBLYPROPERTY (Transact-SQL) |
ASSEMBLYPROPERTY (Transact-SQL) |
markingmyname |
maghan |
07/24/2017 |
sql |
t-sql |
reference |
|
|
|
[!INCLUDE SQL Server Azure SQL Managed Instance]
This function returns information about a property of an assembly.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
ASSEMBLYPROPERTY('assembly_name', 'property_name')
assembly_name
The name of the assembly.
property_name
The name of a property about which to retrieve information. property_name can have 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
This example assumes a HelloWorld assembly that is registered in the [!INCLUDEssSampleDBobject] database. For more information, see Hello World Sample.
USE AdventureWorks2022;
GO
SELECT ASSEMBLYPROPERTY ('HelloWorld' , 'PublicKey');