ODBC guide

List files

Gets all files from a specific drive (document library).

SELECT * FROM list_files
WITH (
  -- Drive (SharePoint Document Library)
  DriveId='b!GtLN726LE0eY5F2BBNi14wMKmwdpCDFMn1d71ra11GuQ4DORpHy-XXXXXXXXXXXXX'
)
--You can get DriveId by selecting from 'Drives' table.