I have a landing page that needs to display a list of all the records in a data extension in real time. In the past we have done this with a subset of the data using the LookupRows function. This works great, but from what I can see it only returns a subset not the entire data extension.

Is there a way in ampscript to return all the rows from a Data Extension?

1 Answer 1


The only way I know of to do this is to create a field in the data extension that has a default value, since this value will be the same for every record you use this field/value pair as your lookup criteria.

So for example add a field called "return", with a default value of "1". Then use this code:

LookupRows("YOUR DE NAME","return","1")

This isn't recommended for large data sets.

  • I had discovered this before posting this, but I wondered if there was a better way. It appears there isn't. Thanks for the reply.
    – parkinsona
    May 20, 2014 at 1:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.