Finding SQL Scripts that populate table

Question

I've inherited tables and am being asked what parameters are being used in populating the tables. I've found the script that creates the table, but where do I look to find the procedure(s) that are run when the tables are "automatically" updated?

Example: Table contains aggregated data. I need to know if the table includes all instances of a unique identifier with different issue dates or if it just includes data with the most recent issue date.

Answer 1

That is not an entirely simple question to answer, since there are so many possibilities. It could be stored procedures, it could be ad-hoc statements from the client.

I have an article on my web site Where Is that Table Used? which discusses various approaches. You may to apply more than one of them.

Answer 2

Hi @Anna Adams

Although you gave an example, that is only a general description. You can refer to Erland's article to see if it solves your problem.

If you need us to help you design the script, you need to provide more detailed information.

Best regards,

Percy Tang