Finding all tables with a particular field?
From: Fred Wilson <faNOWilsonSPAM_at_comcast.net>
Date: Sun, 17 Sep 2006 21:30:48 -0400
Message-ID: <H5mdnUu8U8Ata5DYnZ2dnUVZ_sSdnZ2d_at_comcast.com>
Hello,
Date: Sun, 17 Sep 2006 21:30:48 -0400
Message-ID: <H5mdnUu8U8Ata5DYnZ2dnUVZ_sSdnZ2d_at_comcast.com>
Hello,
How does one go about finding all the tables that have a particular field name? For example a field name "EVENT_CODE"
I would like to find all the places in the database this is located. Ultimately I want to further find in that field the code "0214" and change it to "0200".
Thank you,
Fred
Received on Mon Sep 18 2006 - 03:30:48 CEST