identify object from object type in sysobject

[Casshern]

Hello,

Is there any way to identify the object from object_type for the table sysobject?

 

object_id             status    object_type       creation_time

118                         1              4                              2013-06-24 13:59:05

119                         1              4                              2013-06-24 13:59:05

120                         1              4                              2013-06-24 13:59:05

121                         1              5                              2013-06-24 13:59:05

122                         1              5                              2013-06-24 13:59:05

123                         1              1                              2013-06-24 13:59:05

124                         1              4                              2013-06-24 13:59:05

125                         1              4                              2013-06-24 13:59:05

126                         1              5                              2013-06-24 13:59:05

[cjd]

1 table
4 column
5 index
cjd

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iqug+uns...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Casshern]

Thanks for that, it a step in right direction but is there a table I could use to identify all the object types in database.  I' running this query

select object_type,count(*) from sysobject group by object_type;

object_type count()

19 3

18 6

17 2

20 8

2 5413

1 21858

6 562

5 1485595

4 1250863

11 3

9 12

8 7

What I would like is to have readable name instead of just a number.

Alan

[cjd]

poke sp_iqobjectinfo () table.
cjd