What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 129 Stack Exchange communities.

If you don't know where to look, it's a bit hard to find the database schema for the Stack Exchange Data Explorer (both new and old). As far as I can tell, the Stack Exchange Data Explorer only provides one clue—in the "About" page—as to the whereabouts of the data schema.

The Stack Exchange trilogy data dumps are hosted at ClearBits!. You can subscribe via RSS and be notified every time a new dump is available. Have fun remixing and reusing; all we ask is for proper attribution.

However, I would argue that this answer on Meta Stack Overflow provides the most accessible overview of the database schema. Can someone add this to the Data Explorer FAQ or show at least show me where it is prominently displayed on a Data Explorer page?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

As far as I can tell, the Stack Exchange Data Explorer only provides one clue—in the "About" page—as to the whereabouts of the data schema

Well, the schema is also shown under the Compose Query section as long as you don't block scripts from microsoft.com.

schema-hidden

schema-shown

share|improve this answer
    
D'oh! You're absolutely right. I had a script-blocker enabled, and that prevented the Microsoft-provided schema from being displayed. –  Chris Frederick Sep 12 '11 at 7:00
    
@Chris :) thanks for updating my answer as well. Also, Microsoft provided schema? :-s –  Sathya Sep 12 '11 at 10:18
    
Er, what I meant to say was that the schema was shown by a script from microsoft.com and thus "Microsoft-provided". –  Chris Frederick Sep 12 '11 at 16:15
    
@Chris ah okay! –  Sathya Sep 12 '11 at 16:54

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .