Showing:

Diagrams
Instances
Model
Properties
Source
Used by
Element revoke_role_statement
Namespace http://www.sqlparser.com/xml/ansi2003
Diagram
Diagram ansi2003_xsd_Element_kw_revoke.tmp#kw_revoke ansi2003_xsd_Element_revoke_role_statement.tmp#revoke_role_statement_admin_option_for ansi2003_xsd_Element_role_revoked.tmp#role_revoked ansi2003_xsd_Element_kw_from.tmp#kw_from ansi2003_xsd_Element_grantee.tmp#grantee ansi2003_xsd_Element_granted_by_grantor.tmp#granted_by_grantor ansi2003_xsd_Element_drop_behavior.tmp#drop_behavior
Properties
content complex
Used by
Model
Children admin_option_for, drop_behavior, granted_by_grantor, grantee, kw_from, kw_revoke, role_revoked
Instance
<revoke_role_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_revoke>{1,1}</kw_revoke>
  <admin_option_for>{0,1}</admin_option_for>
  <role_revoked>{1,unbounded}</role_revoked>
  <kw_from>{1,1}</kw_from>
  <grantee>{1,unbounded}</grantee>
  <granted_by_grantor>{0,1}</granted_by_grantor>
  <drop_behavior>{1,1}</drop_behavior>
</revoke_role_statement>
Source
<xs:element name="revoke_role_statement">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_revoke"/>
      <xs:element name="admin_option_for" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_admin"/>
            <xs:element ref="kw_option"/>
            <xs:element ref="kw_for"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="role_revoked" maxOccurs="unbounded"/>
      <xs:element ref="kw_from"/>
      <xs:element ref="grantee" maxOccurs="unbounded"/>
      <xs:element ref="granted_by_grantor" minOccurs="0"/>
      <xs:element ref="drop_behavior"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>
Element revoke_role_statement / admin_option_for
Namespace http://www.sqlparser.com/xml/ansi2003
Diagram
Diagram ansi2003_xsd_Element_kw_admin.tmp#kw_admin ansi2003_xsd_Element_kw_option.tmp#kw_option ansi2003_xsd_Element_kw_for.tmp#kw_for
Properties
content complex
minOccurs 0
Model
Children kw_admin, kw_for, kw_option
Instance
<admin_option_for xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_admin>{1,1}</kw_admin>
  <kw_option>{1,1}</kw_option>
  <kw_for>{1,1}</kw_for>
</admin_option_for>
Source
<xs:element name="admin_option_for" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_admin"/>
      <xs:element ref="kw_option"/>
      <xs:element ref="kw_for"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>