Use the AMPscript Data Extension functions to manage data extensions and marketing objects and work with the data that they contain.
This table lists all AMPscript functions related to managing data extensions. The value in the Engagement column indicates whether Marketing Cloud Engagement supports the function. The value in the Next column indicates whether Marketing Cloud Next supports the function.
| Function Name | Description | Engagement | Next |
|---|---|---|---|
| ClaimRow() | Returns the first unclaimed row from a data extension. | ✅ Yes | ✅ Yes |
| ClaimRowValue() | Searches a data extension for an unclaimed row and returns a value from that row. | ✅ Yes | ✅ Yes |
| DataExtensionRowCount() | Returns the number of rows in a data extension. | ✅ Yes | ❌ No |
| DeleteData() | Deletes rows from a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No |
| DeleteDE() | Deletes rows from a data extension in an email. | ✅ Yes | ❌ No |
| ExecuteFilter() | Executes a data filter and returns an unordered rowset that contains the results. | ✅ Yes | ❌ No |
| ExecuteFilterOrderedRows() | Executes a data filter and returns an ordered rowset that contains the results. | ✅ Yes | ❌ No |
| InsertData() | Inserts rows into a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No |
| InsertDE() | Inserts rows into a data extension in emails. | ✅ Yes | ❌ No |
| Field() | Returns a specific field from a data row or record. | ✅ Yes | ✅ Yes |
| Lookup() | Returns a value from a data extension or marketing object. | ✅ Yes | ✅ Yes |
| LookupOrderedRows() | Returns rows from a data extension sorted in ascending or descending order (case-insensitive). | ✅ Yes | ✅ Yes |
| LookupOrderedRowsCS() | Returns rows from a data extension sorted in ascending or descending order (case-sensitive). | ✅ Yes | ❌ No |
| LookupRows() | Returns an unordered rowset from a data extension (case-insensitive). | ✅ Yes | ✅ Yes |
| LookupRowsCS() | Returns an unordered rowset from a data extension (case-sensitive). | ✅ Yes | ❌ No |
| Row() | Returns a row from a rowset, array, or object. | ✅ Yes | ✅ Yes |
| RowCount() | Returns the number of rows in a rowset, array, or object. | ✅ Yes | ✅ Yes |
| UpdateData() | Updates data in a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No |
| UpdateDE() | Updates data in a data extension in emails. | ✅ Yes | ❌ No |
| UpsertData() | Upserts data in a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No |
| UpsertDE() | Upserts data in a data extension in emails. | ✅ Yes | ❌ No |