USE tempdb
GO

IF OBJECT_ID('T1') IS NOT NULL
DROP TABLE T1
GO

DROP XML SCHEMA COLLECTION T1Sch
GO

CREATE XML SCHEMA COLLECTION T1Sch AS
'<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
 <xs:simpleType name="int1_4_7_10">
 <xs:restriction base="xs:nonNegativeInteger">
 <!-- <xs:maxInclusive value="100"></xs:maxInclusive> -->
 <xs:enumeration value="1"></xs:enumeration>
 <xs:enumeration value="4"/>
 <xs:enumeration value="7"/>
 <xs:enumeration value="10"/>
 </xs:restriction>
 </xs:simpleType>
 <xs:element name="Matrix">
 <xs:complexType>
 <xs:sequence>
 <xs:element maxOccurs="unbounded" name="row">
 <xs:complexType>
 <xs:attribute name="Col1" type=" int1_4_7_10" use="required" />
 <xs:attribute name="Col2" type="xs:int" use="required" />
 <xs:attribute name="Col3" type="xs:int" use="required" />
 </xs:complexType>
 </xs:element>
 </xs:sequence>
 </xs:complexType>
 </xs:element>
</xs:schema>
';
GO

------ Zoznam schema collections:
SELECT * FROM sys.xml_schema_collections

------ Zoznam namespaces:
SELECT name FROM sys.xml_schema_namespaces

CREATE TABLE T1 (
 i int,
 x xml (T1Sch))
GO

INSERT INTO T1 VALUES(1,
'<Matrix>
 <row Col1="1" Col2="2" Col3="3" />
 <row Col1="4" Col2="5" Col3="6" />
 <row Col1="7" Col2="8" Col3="9" />
 <row Col1="11" Col2="11" Col3="12" />
</Matrix>
')
SELECT * FROM T1;