Hi all,

We have another company working on a possible replacement for one of my apps. They are asking for the table definitions as xml files so they can use it for some data modelling. I said "sure" last week and then realized when I went to do it today (when I have time), I forgot to ask them what the output tags should be like. Is there a schema published for SQL server (not actually sure what they are using for modelling). I wanted to do this today but they are not available for a couple days.

Here is the output for a table if I first use COPY STRUCTURE EXTENDED and then use cursortoxml() to output to an xml file.

On the below, I removed most of the fields past the first 5 (although I don't really know what is required at the other end).

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
<VFPData>
	<partfiledef>
		<field_name>File_id</field_name>
		<field_type>N</field_type>
		<field_len>6</field_len>
		<field_dec>0</field_dec>
		<field_null>false</field_null>
	</partfiledef>
.....

I searched for "SQL Server XML table definition schema" but did not get any pertinent matches.

Thanks.