Example of an UpdateMetadata Request That Deletes an Association

The following UpdateMetadata request deletes the KeyedColumns association added in the second example in Example of an UpdateMetadata Request That Merges Associations:

<UpdateMetadata>
  <Metadata>
     <UniqueKey Id="A53TPPVI.A8000001">
       <KeyedColumns Function="Remove">
           <Column Id="A53TPPVI.A5000006" Name="Address"/>
       </KeyedColumns>
     </UniqueKey>
  </Metadata>
  <NS>SAS</NS>
  <!-- OMI_TRUSTED_CLIENT Flag -->
  <Flags>268435456</Flags>  
  <Options/>
</UpdateMetadata>

The Function="REMOVE" directive instructs the SAS Metadata Server to remove the specified association from the UniqueKey object's KeyedColumns association list. If Function="REPLACE" had been specified, the existing KeyedColumns association list would have been replaced with the specified association.

Here are the results of a GetMetadata call that gets a revised KeyedColumns associations list:

<!-- Using the GETMETADATA method. -->

<UniqueKey Id="A53TPPVI.A8000001" Name="Sales Associates in NW Region">
<KeyedColumns>
<Column Id="A53TPPVI.A5000005" Name="EmployeeName" Desc="Name of employee"/>
</KeyedColumns>
</UniqueKey>

For more information about the use of REMOVE versus REPLACE, see Deleting Associations.