it is in AllDocs Table,use this:
SELECT top 10 [Id]
,[SiteId]
,[DirName]
,[LeafName]
,[WebId]
,[ListId]
,[DoclibRowId]
,[Type]
,[SortBehavior]
,[Size]
,[ETagVersion]
,[EffectiveVersion]
,[InternalVersion]
,[BumpVersion]
,[UIVersion]
,[Dirty]
,[ListDataDirty]
,[CacheParseId]
,[DocFlags]
,[ThicketFlag]
,[CharSet]
,[ProgId]
,[TimeCreated]
,[TimeLastModified]
,[NextToLastTimeModified]
,[MetaInfoTimeLastModified]
,[TimeLastWritten]
,[DeleteTransactionId]
,[SetupPathVersion]
,[SetupPath]
,[SetupPathUser]
,[CheckoutUserId]
,[CheckoutDate]
,[CheckoutExpires]
,[VersionCreatedSinceSTCheckout]
,[LTCheckoutUserId]
,[VirusVendorID]
,[VirusStatus]
,[VirusInfo]
,[MetaInfo]
,[MetaInfoSize]
,[MetaInfoVersion]
,[UnVersionedMetaInfo]
,[UnVersionedMetaInfoSize]
,[UnVersionedMetaInfoVersion]
,[WelcomePageUrl]
,[WelcomePageParameters]
,[IsCurrentVersion]
,[Level]
,[CheckinComment]
,[AuditFlags]
,[InheritAuditFlags]
,[DraftOwnerId]
,[UIVersionString]
,[ParentId]
,[HasStream]
,[ScopeId]
,[BuildDependencySet]
,[ParentVersion]
,[ParentVersionString]
,[TransformerId]
,[ParentLeafName]
,[IsCheckoutToLocal]
,[CtoOffset]
,[Extension]
,[ExtensionForFile]
,[ItemChildCount]
,[FolderChildCount]
,[FileFormatMetaInfo]
,[FileFormatMetaInfoSize]
,[FFMConsistent]
,[ContentVersion]
,[ListSchemaVersion]
,[ClientId]
FROM [WSS_Content].[dbo].[AllDocs]
order by TimeCreated desc