PST_ARCHIVE_FILES Table

An Archive File Collection includes a table named PST_ARCHIVE_FILES, which contains a row for each Archive File in the collection.

PST_ARCHIVE_FILES has the following columns:

Column Name Data Type Description
ARCHIVE_ID INTEGER Archive File ID
GUID CHAR(40) Archive File GUID
ARCHIVE_FILE_NAME VARCHAR(256) Archive File name
ARCHIVE_DATETIME TIMESTAMP Archive File creation date and time

You can use this table to query context data from the Archive Files in the collection. For example, use the following syntax to find the latest Archive File ID:

SELECT MAX(ARCHIVE_ID) FROM PST_ARCHIVE_FILES


Feedback