Finding Tables

  • I have a web application that has a few hundred drop-down lists. Each dropdown list has values that represent data which is updated in the database. I need to figure out the table that the drop-down list belongs to or makes changes to. For example, on a banking website, you may have a drop-down list that lets you change the Account Status. The values for account status could be "Active", "On Hold" etc. Given such values, what is the best way to figure out where these values are stored in the backend database?

  • I'd say you can find all that info by looking at the query / recordset that fills the query.  If the query is a stored proc (as it should).  You'll have to find the text of the proc on the server and find your answers there!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply