Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE dbFad01_roadmapinanestesia
- CREATE XML SCHEMA COLLECTION SponsorSchema AS
- N'<?xml version="1.0" encoding="UTF-16"?>
- <xs:schema id="sponsors" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
- <xs:element name="sponsors" msdata:IsDataSet="true" msdata:Locale="en-US">
- <xs:complexType>
- <xs:choice minOccurs="0" maxOccurs="unbounded">
- <xs:element name="sponsor" nillable="true">
- <xs:complexType>
- <xs:simpleContent msdata:ColumnName="sponsor_Text" msdata:Ordinal="0">
- <xs:extension base="xs:string">
- </xs:extension>
- </xs:simpleContent>
- </xs:complexType>
- </xs:element>
- </xs:choice>
- </xs:complexType>
- </xs:element>
- </xs:schema>' ;
- GO
- -- Verify - list of collections in the database.
- SELECT *
- FROM sys.xml_schema_collections
- -- Verify - list of namespaces in the database.
- SELECT name
- FROM sys.xml_schema_namespaces
Advertisement
Add Comment
Please, Sign In to add comment