Filtering SQL Server sys.objects by database Filtering SQL Server sys.objects by database database database

Filtering SQL Server sys.objects by database


Each Database have its own sys.objects, so you have to get the databases from sys.databases, and

select from {dbname}.sys.objects

{dbname} is the name from sys.databases