DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
paulchacko 4/14/2017 3:31:58 PM

Find table and field a particular value reside

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu
There are times (when we create a report in Crystal or SSRS or run an update statement in SQL), we want to know in which table and field a particular value resides. It can be a tedious and boring process to sift through all the table & field suspects in the DB.

Let's take an example. I want to update all the CHECKBOOK ID fields for all the Customers in the DB. I want to run an UPDATE statement such as:

UPDATE [TABLE] SET [XXXXX] WHERE CHECKBOOKID = 'BANKOFNY' and CUSTNMBR ='ABCD001'

But I do not know what fields in the RM00100 needs to be updated.

Version: GP 8,GP 10,GP 2010,GP 2013,GP 2015
Section: Dynamics GP,VBA,Report Writer,SQL Scripts,Crystal Reports,SSRS