CLR Assembly Catalog Views

Se more view version maps here: Microsoft Sql System View Version Maps

• sys.assemblies
• sys.assembly_files
• sys.assembly_references

sys.assemblies

assembly.

Column name	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	Type	Description
name	•	•	•	•	sysname	Name of the assembly. Is unique within the database.
principal_id	•	•	•	•	int	ID of the principal that owns this assembly.
assembly_id	•	•	•	•	int	Assembly identification number. Is unique within a database.
clr_name	•	•	•	•	nvarchar(4000)	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.
permission_set	•	•	•	•	tinyint	Permission-set/security-level for assembly. 1 = Safe Access 2 = External Access 3 = Unsafe Access
permission_set_desc	•	•	•	•	nvarchar(60)	Description for permission-set/security-level for assembly. SAFE_ACCESS EXTERNAL_ACCESS UNSAFE_ACCESS
is_visible	•	•	•	•	bit	1 = Assembly is visible to register Transact-SQL entry points. 0 = Assembly is intended only for managed callers. That is, the assembly provides internal implementation for other assemblies in the database.
create_date	•	•	•	•	datetime	Date the assembly was created or registered.
modify_date	•	•	•	•	datetime	Date the assembly was modified.
is_user_defined		•	•	•	bit	Indicates the source of the assembly. 0 = System-defined assemblies (such as Microsoft.SqlServer.Types for the hierarchyid data type) 1 = User-defined assemblies

TSQL

Sql 2005
SELECT [name], [principal_id], [assembly_id], [clr_name], [permission_set], [permission_set_desc], [is_visible], [create_date], [modify_date] FROM sys.assemblies
Sql 2008
SELECT [name], [principal_id], [assembly_id], [clr_name], [permission_set], [permission_set_desc], [is_visible], [create_date], [modify_date], [is_user_defined] FROM sys.assemblies
Sql 2008 R2
SELECT [name], [principal_id], [assembly_id], [clr_name], [permission_set], [permission_set_desc], [is_visible], [create_date], [modify_date], [is_user_defined] FROM sys.assemblies
Sql 2012
SELECT [name], [principal_id], [assembly_id], [clr_name], [permission_set], [permission_set_desc], [is_visible], [create_date], [modify_date], [is_user_defined] FROM sys.assemblies

Back to Top

---

sys.assembly_files

file that makes up an assembly.

Column name	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	Type	Description
assembly_id	•	•	•	•	int	ID of the assembly to which this file belongs.
name	•	•	•	•	nvarchar(260)	Name of the assembly file.
file_id	•	•	•	•	int	ID of the file. Is unique within an assembly. The file ID numbered 1 represents the assembly DLL.
content	•	•	•	•	varbinary(max)	Content of file.

TSQL

Sql 2005
SELECT [assembly_id], [name], [file_id], [content] FROM sys.assembly_files
Sql 2008
SELECT [assembly_id], [name], [file_id], [content] FROM sys.assembly_files
Sql 2008 R2
SELECT [assembly_id], [name], [file_id], [content] FROM sys.assembly_files
Sql 2012
SELECT [assembly_id], [name], [file_id], [content] FROM sys.assembly_files

Back to Top

---

sys.assembly_references

pair of assemblies where one is directly referencing another.

Column name	Sql 2005	Sql 2008	Sql 2008 R2	Sql 2012	Type	Description
assembly_id	•	•	•	•	int	ID of the assembly to which this reference belongs.
referenced_assembly_id	•	•	•	•	int	ID of the assembly being referenced.

TSQL

Sql 2005
SELECT [assembly_id], [referenced_assembly_id] FROM sys.assembly_references
Sql 2008
SELECT [assembly_id], [referenced_assembly_id] FROM sys.assembly_references
Sql 2008 R2
SELECT [assembly_id], [referenced_assembly_id] FROM sys.assembly_references
Sql 2012
SELECT [assembly_id], [referenced_assembly_id] FROM sys.assembly_references

Back to Top

---