<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="NewDataSet" 
           xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" 
           xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
           xmlns:sql="urn:schemas-microsoft-com:mapping-schema"
>

  <xs:element name="root" 
              sql:relation="Ping" 
              sql:overflow-field="OverflowColumn"
              sql:key-fields="health_status"
  >
    <xs:complexType>
      <xs:sequence>

        <xs:element name="health_status" nillable="true" minOccurs="0" maxOccurs="1" sql:datatype="nvarchar(128)">
          <xs:complexType>
            <xs:simpleContent msdata:ColumnName="health_status_Text" msdata:Ordinal="1">
              <xs:extension base="xs:string" >
              </xs:extension>
            </xs:simpleContent>
          </xs:complexType>
        </xs:element>
      </xs:sequence>

    </xs:complexType>
  </xs:element>

</xs:schema>

CREATE TABLE [dbo].[Ping](
	[OverflowColumn] [ntext] NULL,
	[health_status] [nvarchar](128) NOT NULL
 CONSTRAINT [Ping_pk_1] PRIMARY KEY CLUSTERED 
(
	[health_status] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY