| Author |
Message |
austrianfoodispuke
Joined: 05 May 2008
Posts: 59
|
 Posted: Mon May 05, 2008 3:12 pm Post subject: type of object used is not listed in xml output |
 |
|
the object type is listed, but the object being used by this is not
why not? |
|
| Back to top |
|
 |
Brian Donahue
Joined: 23 Aug 2004
Posts: 6344
Location: Red Gate Software
|
| Posted: Fri May 23, 2008 12:55 pm Post subject: |
|
|
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:
| Code: |
- <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:
| Code: |
| Object[@name='[(local)].[F0012191].[dbo].[a]']/Type |
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
