You'd have to create a query that produces the FOR XML and supply a predicate in the WHERE clause that always evaluates to FALSE.

-Mike

>Hi,
>
>I have 4 tables that I would like to join... and produce an xml schema
>Now, I know that the FOR XML OUTPUT does this... but
>
>--> How do I create an xml schema using sql without returning the data
>
>
>Any ideas,
>
>Thanks,
>
>Alvin