Update Column Properties for a Data Extension

This page contains information about updating the properties of a column within an existing data extension.

Why Update Column Properties for an Existing Data Extension

You can update column properties in an existing data extension to change how the data extension handles information. For example, you can change the number of characters allowed within a field as necessary.

How to Update Column Properties for an Existing Data Extension

Note that you must specify the ObjectID for the DataExtensionField object to ensure you update the correct field. Otherwise, the SOAP API tries to add the update as a new column with the same name as the existing column and produces an error. Use the Retrieve method on the DataExtensionField object to vind the ObjectID value. Use the sample code below as a model for your own API calls:

Sample .NET File

Sample SOAP Envelope