What are the different options to generate an XML Schema Collection?

Option 1 - CREATE XML SCHEMA COLLECTION XXX AS ‘…’

Option 2 - Use Microsoft XSD inference tool 


Option 4 - In BIDS 2005+, copy the xml code from SSMS to the xml editor window in VS or BIDS, from the XML menu, choose Generate Schema. See below for details: