Find all Database Objects by Name?

Question

How can I find all database objects in a given database using an object name? We prefix all site specific tables, views, indexes, functions, constraints etc. with a constant string. I need to find all objects with names starting with that string.

Answer 1

Assuming you have the right permissions:

SELECT *
FROM database.sys.all_objects
WHERE upper(name) like upper('my prefix%')  --use UPPER for case-INsensitivity