some tips about sys.objects table

all database objects are stored in sys.objects table. they can be classified as following type:
U ==> normal table
V ==> View
S ==> System table
P ==> Store Procedure
...

for example, if we 'd like to query all tables which are named with ds_in_*, we can write like this:
    select 
            object_id,name
    from 
            sys.objects
    where 
            type='U' 
            and name like 'ds_in_%'