--- schema_version: "1" id: 1ba7060bf944f457471d22f24afb57e70128fb10bdc743ad7e9e21f4f5258d41 title: AMPscript Data Extension & Marketing Object Functions collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/marketing-cloud/ampscript/references/data-extension/mc-ampscript-reference-data-extension.md canonical_url: https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension.html source_site: developer.salesforce.com content_type: documentation content_hash: 48681f74c7eb7de46929d1c79153e181da9906d31d05f16552e1d6f8426b6df1 products: - AMPscript for Marketing Cloud - Marketing Cloud --- # AMPscript Data Extension & Marketing Object Functions 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()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-claim-row.md) | Returns the first unclaimed row from a data extension. | ✅ Yes | ✅ Yes | | [ClaimRowValue()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-claim-row-value.md) | Searches a data extension for an unclaimed row and returns a value from that row. | ✅ Yes | ✅ Yes | | [DataExtensionRowCount()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-de-row-count.md) | Returns the number of rows in a data extension. | ✅ Yes | ❌ No | | [DeleteData()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-delete-data.md) | Deletes rows from a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No | | [DeleteDE()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-delete-de.md) | Deletes rows from a data extension in an email. | ✅ Yes | ❌ No | | [ExecuteFilter()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-execute-filter.md) | Executes a data filter and returns an unordered rowset that contains the results. | ✅ Yes | ❌ No | | [ExecuteFilterOrderedRows()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-execute-filter-ordered-rows.md) | Executes a data filter and returns an ordered rowset that contains the results. | ✅ Yes | ❌ No | | [InsertData()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-insert-data.md) | Inserts rows into a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No | | [InsertDE()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-insert-de.md) | Inserts rows into a data extension in emails. | ✅ Yes | ❌ No | | [Field()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-field.md) | Returns a specific field from a data row or record. | ✅ Yes | ✅ Yes | | [Lookup()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-lookup.md) | Returns a value from a data extension or marketing object. | ✅ Yes | ✅ Yes | | [LookupOrderedRows()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-lookup-ordered-rows.md) | Returns rows from a data extension sorted in ascending or descending order (case-insensitive). | ✅ Yes | ✅ Yes | | [LookupOrderedRowsCS()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-lookup-ordered-rows-cs.md) | Returns rows from a data extension sorted in ascending or descending order (case-sensitive). | ✅ Yes | ❌ No | | [LookupRows()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-lookup-rows.md) | Returns an unordered rowset from a data extension (case-insensitive). | ✅ Yes | ✅ Yes | | [LookupRowsCS()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-lookup-rows-cs.md) | Returns an unordered rowset from a data extension (case-sensitive). | ✅ Yes | ❌ No | | [Row()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-row.md) | Returns a row from a rowset, array, or object. | ✅ Yes | ✅ Yes | | [RowCount()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-row-count.md) | Returns the number of rows in a rowset, array, or object. | ✅ Yes | ✅ Yes | | [UpdateData()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-update-data.md) | Updates data in a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No | | [UpdateDE()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-update-de.md) | Updates data in a data extension in emails. | ✅ Yes | ❌ No | | [UpsertData()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-upsert-data.md) | Upserts data in a data extension in CloudPages, microsites, landing pages, and SMS messages. | ✅ Yes | ❌ No | | [UpsertDE()](https://developer.salesforce.com/docs/marketing/marketing-cloud-ampscript/references/mc-ampscript-data-extension/mc-ampscript-reference-data-extension-upsert-de.md) | Upserts data in a data extension in emails. | ✅ Yes | ❌ No |