type of object used is not listed in xml output

austrianfoodispuke

the object type is listed, but the object being used by this is not

why not?

Brian Donahue

Hi Nik,

The schema of the XML export does not define the object type of dependent objects in order to reduce the size of the XML by not repeating information that is available elsewhere. For example, the XML output could show the following:

- <Object>
  <Name>[(local)].[F0012191].[dbo].[fn_MyExample]</Name> 
  <Type>Function</Type> 
- <Uses>
  <Object>[(local)].[F0012191].[dbo].[a]</Object> 
  <Object>[(local)].[F0012191].[dbo].[b]</Object> 
  <Object>[(local)].[F0012191].[dbo].[c]</Object> 
  <Object>[(local)].[F0012191].[dbo].[d]</Object> 
  </Uses>

In this case, the list of objects that fn_MyExample uses does not include the full information about these objects because it is expressed elsewhere.

If you had to parse this XML in order to transform it to HTML or something like that, you can use an XPATH query to select the dependent object by name and get the object type from the object definition. For instance, you could work out the type of object a with this query:

Object[@name='[(local)].[F0012191].[dbo].[a]']/Type