This is a handy bit of code to generate an XSD schema for a database:
DECLARE @listStr VARCHAR(MAX)SELECT @listStr = COALESCE(@listStr+',' ,'') + TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'EXEC(' DECLARE @schema xml SET @schema = (SELECT TOP 0 * FROM ' + @listStr + ' FOR XML AUTO, ELEMENTS, XMLSCHEMA(''DbSchema'')) SELECT @schema ');