StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14879320
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-02-14T16:21:34.930
FavoriteCount
0
LastActivityDate
2013-02-15T11:34:48.363
LastEditDate
2013-02-15T11:34:48.363
LastEditorUserId
1113475
OwnerUserId
1113475
ParentId
14878571
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
You could do it via a macro. First append a large number of zeroes to the end of each line using a macro. <ol> <li>Caret on the first entry</li> <li>click record macro</li> <li>press <code>end</code></li> <li>type out 20 zeroes</li> <li>press <code>down arrow</code></li> <li>click stop recording</li> <li>play the macro until all lines look like this 11111111111111111100000000000000000000000000000000000000000000 16661666666666366100000000000000000000000000000000000000000000 16661111111111166100000000000000000000000000000000000000000000 16666636666366166100000000000000000000000000000000000000000000 11316111111116161100000000000000000000000000000000000000000000 131616666661616100000000000000000000000000000000000000000000 161616226261616100000000000000000000000000000000000000000000 1161616611261616100000000000000000000000000000000000000000000 1661616611661616100000000000000000000000000000000000000000000 1661616226261616100000000000000000000000000000000000000000000 1661616626661616100000000000000000000000000000000000000000000 1661611116111616100000000000000000000000000000000000000000000 166166666666661611100000000000000000000000000000000000000000000 166166616616336666100000000000000000000000000000000000000000000 164166616616661366100000000000000000000000000000000000000000000 111111111111111111100000000000000000000000000000000000000000000</li> </ol> Then... <ol> <li>Caret on first line</li> <li>click record</li> <li>press <code>home</code> key</li> <li>press the <code>right arrow</code> key 20 times</li> <li>hold <code>shift</code> and press <code>end</code> key</li> <li>press <code>delete</code> key</li> <li>press <code>down arrow</code></li> <li>click stop recording</li> <li>play the macro until all lines are processed</li> </ol> You could save the entire process as a single macro so its just a single click in the future.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAdd trailing zeroes to line in notepad++
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USKevin Brydon
UserOwnerUserId
1. USKevin Brydon
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POAdd trailing zeroes to line in notepad++
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThanks for your answer.
 singulars
 PostPostId
 PO
 UserUserId
 USomegaFlame

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.