ALLCOLUMNSLIST
- Last Updated: October 18, 2021
- 1 minute read
- DataDirect Connectors
- JDBC
- Microsoft Sharepoint 6.0
- Documentation
Columns
The ALLCOLUMNSLIST table includes internal SharePoint columns, as well as user-specified columns.
The internal columns are exposed when the AuditColumns connection property is set to
All. The ID column marked with an asterisk is the primary
key.
| Column Name | Data Type |
|---|---|
| ID* | INT32 |
| _COMPLIANCEFLAGS | STRING(255) |
| _COMPLIANCETAG | STRING(255) |
| _COMPLIANCETAGUSERID | STRING(255) |
| _COMPLIANCETAGWRITTENTIME | STRING(255) |
| _ISRECORD | STRING(255) |
| _UIVERSIONSTRING | STRING(255) |
| APPAUTHOR | STRING(255) |
| APPEDITOR | STRING(255) |
| ATTACHMENTS | STRING(255) |
| AUTHOR | STRING(255) |
| BOOLEANCOL | BOOLEAN |
| CHOICECOL | STRING(255) |
| COMPLIANCEASSETID | STRING(255) |
| CONTENTTYPE | STRING(255) |
| CONTENTTYPE_ID | STRING(2000) |
| CONTENTTYPE_NAME | STRING(2000) |
| CREATED | DATETIMEOFFSET(26) |
| CREATEDBY_APPLICATION_DISPLAYNAME | STRING(2000) |
| CREATEDBY_APPLICATION_EMAIL | STRING(2000) |
| CREATEDBY_APPLICATION_ID | STRING(2000) |
| CREATEDBY_APPLICATION_USERPRINCIPALNAME | STRING(2000) |
| CREATEDBY_GROUP_DISPLAYNAME | STRING(2000) |
| CREATEDBY_GROUP_EMAIL | STRING(2000) |
| CREATEDBY_GROUP_ID | STRING(2000) |
| CREATEDBY_GROUP_USERPRINCIPALNAME | STRING(2000) |
| CREATEDBY_USER_DISPLAYNAME | STRING(2000) |
| CREATEDBY_USER_EMAIL | STRING(2000) |
| CREATEDBY_USER_ID | STRING(2000) |
| CREATEDBY_USER_USERPRINCIPALNAME | STRING(2000) |
| CREATEDDATETIME | DATETIMEOFFSET(26) |
| CURRENCYCOL | DECIMAL(19, 4) |
| DESCRIPTION | STRING(2000) |
| DOCICON | STRING(255) |
| EDIT | STRING(255) |
| EDITOR | STRING(255) |
| ETAG | STRING(2000) |
| FOLDERCHILDCOUNT | STRING(255) |
| ITEMCHILDCOUNT | STRING(255) |
| LASTMODIFIEDBY_APPLICATION_DISPLAYNAME | STRING(2000) |
| LASTMODIFIEDBY_APPLICATION_EMAIL | STRING(2000) |
| LASTMODIFIEDBY_APPLICATION_ID | STRING(2000) |
| LASTMODIFIEDBY_APPLICATION_USERPRINCIPALNAME | STRING(2000) |
| LASTMODIFIEDBY_GROUP_DISPLAYNAME | STRING(2000) |
| LASTMODIFIEDBY_GROUP_EMAIL | STRING(2000) |
| LASTMODIFIEDBY_GROUP_ID | STRING(2000) |
| LASTMODIFIEDBY_GROUP_USERPRINCIPALNAME | STRING(2000) |
| LASTMODIFIEDBY_USER_DISPLAYNAME | STRING(2000) |
| LASTMODIFIEDBY_USER_EMAIL | STRING(2000) |
| LASTMODIFIEDBY_USER_ID | STRING(2000) |
| LASTMODIFIEDBY_USER_USERPRINCIPALNAME | STRING(2000) |
| LASTMODIFIEDDATETIME | DATETIMEOFFSET(26) |
| LINKCOL_DESCRIPTION | STRING(255) |
| LINKCOL_URL | STRING(255) |
| LINKTITLE | STRING(255) |
| LINKTITLENOMENU | STRING(255) |
| LOCATIONCOL_ADDRESS_CITY | STRING(255) |
| LOCATIONCOL_ADDRESS_COUNTRYORREGION | STRING(255) |
| LOCATIONCOL_ADDRESS_POSTALCODE | STRING(255) |
| LOCATIONCOL_ADDRESS_STATE | STRING(255) |
| LOCATIONCOL_ADDRESS_STREET | STRING(255) |
| LOCATIONCOL_COORDINATES_LATITUDE | DOUBLE |
| LOCATIONCOL_COORDINATES_LONGITUDE | DOUBLE |
| LOCATIONCOL_DISPLAYNAME | STRING(255) |
| MODIFIED | DATETIMEOFFSET(26) |
| MULTILINECOL | STRING(63999) |
| NAME | STRING(2000) |
| NUMCOL | DOUBLE |
| PARENTREFERENCE_DRIVEID | STRING(2000) |
| PARENTREFERENCE_DRIVETYPE | STRING(2000) |
| PARENTREFERENCE_ID | STRING(2000) |
| PARENTREFERENCE_LISTID | STRING(2000) |
| PARENTREFERENCE_PATH | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_LISTID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_LISTITEMID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_LISTITEMUNIQUEID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_SITEID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_SITEURL | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_SYNCRESOURCEID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_TENANTDISPLAYNAME | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_TENANTID | STRING(2000) |
| PARENTREFERENCE_SHAREPOINTIDS_WEBID | STRING(2000) |
| PARENTREFERENCE_SITEID | STRING(2000) |
| PERSONCOL | STRING(255) |
| PICTURECOL_DESCRIPTION | STRING(255) |
| PICTURECOL_URL | STRING(255) |
| SHAREPOINTIDS_LISTID | STRING(2000) |
| SHAREPOINTIDS_LISTITEMID | STRING(2000) |
| SHAREPOINTIDS_LISTITEMUNIQUEID | STRING(2000) |
| SHAREPOINTIDS_SITEID | STRING(2000) |
| SHAREPOINTIDS_SITEURL | STRING(2000) |
| SHAREPOINTIDS_SYNCRESOURCEID | STRING(2000) |
| SHAREPOINTIDS_TENANTDISPLAYNAME | STRING(2000) |
| SHAREPOINTIDS_TENANTID | STRING(2000) |
| SHAREPOINTIDS_WEBID | STRING(2000) |
| SINGLELINECOL | STRING(255) |
| TASKCOL | STRING(255) |
| TEXTCOL | STRING(63999) |
| TITLE | STRING(255) |
| WEBURL | STRING(2000) |