SQL tracking number of Selects of a databases table row Hello I'm trying to create a way in which I could track the number of times a certain column in a database table is selected. Is there something I could implement like a trigger that could increment a count column on another table that is associated with the selected row? Trying to figure out which rows in my database tables are used the most.

Thanks, any help is appreciated.
For SQL Server, you could set up an Audit as described in the documentation: SQL Server Audit (Database Engine).


  All editions of SQL Server support server level audits. All editions support database level audits beginning with SQL Server 2016 (13.x) SP1. Prior to that, database level auditing was limited to Enterprise, Developer, and Evaluation editions.


See also Auditing SELECT statements in SQL Server 2008 by Sreekar Mankala.