StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16815321
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-05-29T13:32:25.497
FavoriteCount
0
LastActivityDate
2016-08-18T13:36:38.760
LastEditDate
2016-08-18T13:36:38.760
LastEditorUserId
543577
OwnerUserId
2074825
ParentId
16814040
PostTypeId
2
Score
1
ViewCount
0
LastEditorDisplayName
text
Body
Use the following if you do not wish to use a trial and error method: <pre><code>DECLARE @schema NVARCHAR(20) DECLARE @table NVARCHAR(50) DECLARE @column NVARCHAR(50) DECLARE @SQL NVARCHAR(1000) DECLARE @ID INT DECLARE @exists INT DECLARE @x NVARCHAR(100) SELECT @x = '@exists int output', @ID = 1, @schema = 'dbo', @table = 'Gebruiker', @column = 'GebruikerHasGebruiker_id' SELECT @SQL = 'SELECT @exists = 1 WHERE EXISTS( ' + STUFF(( SELECT ' UNION ALL SELECT ' + U2.COLUMN_NAME + ' AS ID FROM ' + U2.TABLE_SCHEMA + '.' + U2.TABLE_NAME + ' WHERE ' + U2.COLUMN_NAME + ' = ' + cast(@id as VARCHAR(10)) FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS R INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE U ON R.UNIQUE_CONSTRAINT_NAME = U.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE U2 ON R.CONSTRAINT_NAME = U2.CONSTRAINT_NAME WHERE U.TABLE_SCHEMA = @schema AND U.TABLE_NAME = @table AND U.COLUMN_NAME = @column FOR XML PATH('') ),1,11, '') + ')' EXEC sp_executesql @SQL, @x, @exists = @exists OUTPUT IF 1 <> @exists BEGIN -- do you stuff here END </code></pre> But in 99% of the cases you could do this, it's overkill. It is faster if you already know the FKs and just create a query. Edit: A little explanation. This dynamic SQL looks in the INFORMATION SCHEMA to see all relations with other tables. It uses that information to create a query to check if your ID exists in that table. With a UNION it adds all results and returns 1 if any results are found. This can be used for any database, for any column, as long as you don't check for a FK over multiple columns. 
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to check if a column value is referred in some other table as that column is a foreign key in other table (sql server)?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USranieuwe
UserOwnerUserId
1. USEdwin Stoteler
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.