sys.module_assembly_usages (Transact-SQL)
Returns a row for each module-to-assembly reference.
Column name  | 
Data type  | 
Description  | 
|---|---|---|
object_id  | 
int  | 
Object identification number of the SQL object. Is unique within a database.  | 
assembly_id  | 
int  | 
ID of the assembly from which this module was created.  | 
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.