The OneDrive table Folders, which shows all the folders on a drive.

Table Specific Information

Note: See CreateFolder to create a folder.

Projection is done server-side. Also, queries that include the primary key Id and IN are executed server-side, e.g.:

SELECT Id, Name, Size, Description FROM Folders WHERE Id IN ('B1E6BJ084A9133KB1!122', 'APF9D2K6WFAAPX9') 

Folder listing is done recursively via the DirectoryRetrievalDepth property. This property's default value is 5, which means it will get data only for the first 6 levels of the 'Drive' you've chosen (because the first level is located in DirectoryRetrievalDepth=0).

You can specify the value -1 to get all the folders in the 'Drive' no matter the depth they're located in.

While folders may be listed in this view, the contents of the folders may be worked with by using stored procedures such as:

• CopyResource - Copy a file/folder from one directory in your drive to another.
• DeleteResource - Delete a file/folder from your drive.
• MoveResource - Move a file/folder from one directory in your drive to another.

Columns