How Do I Find the XML (XSD) Schema for a Table or View in SQL?

Answer

If you need to find the XML (XSD) schema for a table/view in SQL the following can help:

select top 0 * FROM [table name] FOR XML AUTO, XMLSCHEMA
replace [table name] with appropriate table name