Where are TAGS stored in the DB

If I create or add a tag to a project, in which database table would I find that information?

Based on empirical data, it seems that an entry is created in the table 'ItemTags'  (I see a new entry created where IT_ITEMID = my Project ID and the update stamp seemed appropriate).

However, tag value isn't stored in this table, and I've been unable to find a matching table that might hold the description / IT_TagID information. 

Any suggestions on where I might find this information? ( at the end of the day, I want to select the tags associated with a specific projectID).

The knowledge base articles suggest that the data would be queried as Search Data, but it didn't seem to find the info i was looking for in the table SearchData

 

Tags tags
Asked by Kimberly Clapp on Wed 4/24/24 4:38 PM
Sign In to leave feedback or contribute an answer

Answer (1)

This answer has been marked as the accepted answer
Darin Waldrop Thu 4/25/24 9:49 AM

The Tags are stored in dbo.Tags.  The T_ID field there links to the IT_TagID in dbo.ItemTags, which then links to the project via the IT_ItemID.

1 of 1 users found this helpful.