Table: Outlook_Store | |||
Holds Outlook(R) StoreID values to save space and aid in indexing. Each store_id must be unique. This table does not support updates, only inserts and deletes. Once a record exists it is read-only. "For the Exchange message stores, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook itself." -- Dmitry Streblechenko (MVP) http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd | |||
Columns | |||
Name | Type | Constraints | Description |
outlook_store_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this StoreID so that linking to this StoreID uses only 4 bytes. |
store_id | varbinary (4096) | NOT NULL | Holds the binary value of the Outlook(R) StoreID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. Unique (enforced by a trigger.) |
store_id_checksum | int | NOT NULL | Since the store_id column is wider than 900 bytes, the SQL Server CHECKSUM function is used to compute an indexable column. This column is not unique. |
Primary key | |||
Name | Columns | Description | |
PK_Outlook_Store$outlook_store_KEY | outlook_store_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Outlook_Store$store_id_checksum | store_id_checksum |