DataExtensionField
Represents a field within a data extension.
View-Specific Information
Select
The driver uses the Salesforce Marketing Cloud APIs to process the following WHERE clause operators for all but date-time values: =, !=, <>, >, >=, <, <=, IN. For date-time values, only > and < are supported. The driver processes other filters client-side within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refer to other columns will cause an error.
For example, the following (but not only) queries are processed server side:
SELECT * FROM DataExtensionField SELECT * FROM DataExtensionField WHERE CreatedDate > '2017/01/25'
Columns
| Name | Type | Description |
| ObjectID [KEY] | String | System-controlled, read-only text string identifier for object. |
| PartnerKey | String | Unique identifier provided by partner for an object, accessible only via API. |
| CustomerKey | String | User-supplied unique identifier for an object within an object type, which corresponds to the external key assigned to an object in the user interface. |
| Name | String | Name of the object or property. |
| DefaultValue | String | The default value for a data extension field if no value is supplied. |
| MaxLength | Int | Maximum length of the data. |
| IsRequired | Bool | Indicates whether the property must have a value specified. |
| Ordinal | Int | Indicates position of object within an array |
| IsPrimaryKey | Bool | Designates whether a data extension field is used as a primary key for that data extension. |
| FieldType | String | Designates data type for a data extension field. |
| CreatedDate | Datetime | Read-only date and time of the object's creation. |
| ModifiedDate | Datetime | Indicates the last time object information was modified. |
| Scale | Int | Indicates numeric precision for decimal properties. |
| Client_ID | Int | The Id of the client. |
| DataExtension_CustomerKey | String | User-supplied unique identifier for an object within an object type. |
| StorageType | String | Indicates special storage properties for the field. Valid values are: Unspecified, Plain, Encrypted, or Obfuscated. |