Record Count from all SEDE tables

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

select 'Badges' as [Table], count (*) as [Records] from Badges union 
select 'CloseAsOffTopicReasonTypes' as [Table], count (*) as [Records] from CloseAsOffTopicReasonTypes union 
select 'CloseReasonTypes' as [Table], count (*) as [Records] from CloseReasonTypes union 
select 'Comments' as [Table], count (*) as [Records] from Comments union 
select 'FlagTypes' as [Table], count (*) as [Records] from FlagTypes union 
select 'PendingFlags' as [Table], count (*) as [Records] from PendingFlags union 
select 'PostFeedback' as [Table], count (*) as [Records] from PostFeedback union 
select 'PostHistory' as [Table], count (*) as [Records] from PostHistory union 
select 'PostHistoryTypes' as [Table], count (*) as [Records] from PostHistoryTypes union 
select 'PostLinks' as [Table], count (*) as [Records] from PostLinks union 
select 'PostNotices' as [Table], count (*) as [Records] from PostNotices union 
select 'PostNoticeTypes' as [Table], count (*) as [Records] from PostNoticeTypes union 
select 'Posts' as [Table], count (*) as [Records] from Posts union 
select 'PostsWithDeleted' as [Table], count (*) as [Records] from PostsWithDeleted union 
select 'PostTags' as [Table], count (*) as [Records] from PostTags union 
select 'PostTypes' as [Table], count (*) as [Records] from PostTypes union 
select 'ReviewRejectionReasons' as [Table], count (*) as [Records] from ReviewRejectionReasons union 
select 'ReviewTaskResults' as [Table], count (*) as [Records] from ReviewTaskResults union 
select 'ReviewTaskResultTypes' as [Table], count (*) as [Records] from ReviewTaskResultTypes union 
select 'ReviewTasks' as [Table], count (*) as [Records] from ReviewTasks union 
select 'ReviewTaskStates' as [Table], count (*) as [Records] from ReviewTaskStates union 
select 'ReviewTaskTypes' as [Table], count (*) as [Records] from ReviewTaskTypes union 
select 'SuggestedEdits' as [Table], count (*) as [Records] from SuggestedEdits union 
select 'SuggestedEditVotes' as [Table], count (*) as [Records] from SuggestedEditVotes union 
select 'Tags' as [Table], count (*) as [Records] from Tags union 
select 'TagSynonyms' as [Table], count (*) as [Records] from TagSynonyms union 
select 'Users' as [Table], count (*) as [Records] from Users union 
select 'Votes' as [Table], count (*) as [Records] from Votes union 
select 'VoteTypes' as [Table], count (*) as [Records] from VoteTypes

order by [Records]

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results