Dynamics CRM Attachment table in SQL

In the CRM attachment are classified in to two.

• Notes-where your attachment can save
• Email- Adding your attachment on the email

Notes:

select DocumentBody,FileName, * from AnnotationBase

DocumentBody- base64 string where your attachment details contains

Email:

select * from ActivityMimeAttachmentBase ->Table

select Body, * from ActivityAttachment ->View

Attachment are save in the attachment table

select Body, * from AttachmentTable ->Table