You can import a file into a table:
CREATE TABLE #temp (
dt DATETIME,
col1 XML
)
/*Use the OPENROWSET and BULK load to load an xml file into
the table. GETDATE() is used to populate the first column*/
INSERT #temp
SELECT GETDATE(), *
FROM OPENROWSET(BULK 'C:\Employees.xsd',
SINGLE_BLOB) AS x;
SELECT *
FROM #temp
DROP TABLE #temp
This will import the xsd file into an xml column, but there currently is no native support in SSMS to create a table using xml.
David Dye
