This function returns information about a property of an assembly.
Transact-SQL Syntax Conventions
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 **AdventureWorks2012** database. For more information, see Hello World Sample.