Hi,

What's the proper way to refresh a view? I have a view that's based on a table.

The table has data that changes, and I need to 'refresh' the view so it pulls the data from the table again.

How can I do this? I've tried the REFRESH() command, but that doesn't seem to work.

Thanks,