Talk:Creature tags (Origins)

Obtaining the master list of creature tags
All creatures' tags are defined in the BioWare Dragon Age Toolset SQL database that gets installed along with the Toolset. I used the following query to get the master list of tags. I added a little formatting to the select list so it could be pasted in the Wiki article without further string manipulation. I also used the Results To Text option in SQL Management Studio to make the clipboard copy easier. SELECT '|' + CONVERT(NVARCHAR(MAX), t_StringText.Text) + CHAR(13) + CHAR(10) + '|' + t_ModuleResRefVersion.Folder + CHAR(13) + CHAR(10) + '|' + t_Creature.Tag + CHAR(13) + CHAR(10) + '|-' FROM t_Creature INNER JOIN t_StringText ON t_Creature.NameStringID = t_StringText.StringID INNER JOIN t_ModuleResRefVersion ON t_Creature.ModuleResRefVersionID = t_ModuleResRefVersion.ID ORDER BY CONVERT(NVARCHAR(MAX), Text) ASC, Folder ASC, Tag ASC 173.170.70.26 (talk) 03:50, February 9, 2014 (UTC)