<p>I have a large db with many tables and sprocs, and I want to find and see, for example, if there is a table with a name that has "setting" as part of it.  I'm not very familiar with SqlServer's System Databases like master, msdb etc., I know there is a way to query one of those dbs to get what I need back, does someone know how to do it?</p>

<p>Thank you,
Ray.</p>

the table you want is sys.objects
```
```
SELECT * 
FROM sys.objects
```
```