peter.mauss (10/22/2014)
Yes, it displays theobject_name, the column_name for each hit. It would be cool if it would also Display
the Name of the Primary key column for the object and its value so a further query could be formed later on.
Something like "select [pkey_name],[column_name] from [object_name] where [pkey_name]=[pkey_value]"
Gotcha. The problem is that if it's a view or a table which is a heap then there's no PK. I usually just query the table in question against the column were the result was found using the value returned in the "column_data" column.