if table X is modified(DELETE, INSERT, UPDATE) then table X's metadata value should get incremented.
I can write trigger for the same. But inbuilt solution will be better.
This way I can stop issuing meaningless SELECT queries on the large table, which will give same result as previous.
Server side program can tell clients that nothing changed on server. No need to query.