How to list all CLR objects inside your database?

I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:

SELECT o.object_id AS [Object_ID]
	,schema_name(o.schema_id) + '.' + o.[name] AS [CLRObjectName]
	,o.type_desc AS [CLRType]
	,o.create_date AS [Created]
	,o.modify_date AS [Modified]
	,a.permission_set_desc AS [CLRPermission]
FROM sys.objects o
INNER JOIN sys.module_assembly_usages ma
	ON o.object_id = ma.object_id
INNER JOIN sys.assemblies a
	ON ma.assembly_id = a.assembly_id

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s