Getting Information About Assemblies

The following catalog views and functions can be queried for metadata about assemblies.

To get information about individual assemblies

• ASSEMBLYPROPERTY (Transact-SQL)

To get information about all assemblies in the database

• sys.assemblies (Transact-SQL)

To get information about assembly files, including assembly binaries, source files, and debug files

• sys.assembly_files (Transact-SQL)

To get information about cross-assembly references

• sys.assembly_references (Transact-SQL)

To get assembly information about user-defined types

• sys.assembly_types (Transact-SQL)
• sys.types (Transact-SQL)

To get assembly information about common language runtime (CLR) stored procedures, triggers, and functions

• sys.assembly_modules (Transact-SQL)

To get information about non-CLR objects

• sys.sql_modules (Transact-SQL)

See Also

Concepts

Designing Assemblies
Implementing Assemblies

Other Resources

Assemblies (Database Engine)

Help and Information

Getting SQL Server 2005 Assistance