SharePoint Database SQL Query Tips3

Now, we are going to retrive the file details from AllDocs Database. Which has the informations about the files stored in SharePoint List or Library. — Returns all document from all lists availabe in WebApplication SELECT AllDocs.Leafname AS FileName’,                   AllDOcs.Dirname AS ‘Folder