Webinar_Large VISUAL Online Training Webinar Program

Do you have a training need and little time to develop an internal training program? How do you currently handle training of new employees, cross-train or retrain users? If this is your business challenge, our VISUAL ERP web-based training program was designed especially for you! 

50+ webinars for every VISUAL users. Tell me More!

Written by Richard on September 9, 2010

Searching all the tables that reference a particular data field (column name)

Here's one for your bag of tricks ... and we can all thank Dave Giusto (once again).

Use the following script (for SQL Server..sorry) when you what to find out all the places where a piece a data may be stored in the visual tables. 

To use the script:

  1. Download the SQL server script Tables & Views Search Script
     
  2. Open SQL Server Management Studio
     
  3. Select the visual database and click on the New Query
     
  4. Paste the script in the query window
     
  5. Modify the script to search for the data(column) you want. To do this, set the @col_name variable to the name of the column. You can use the '%' as a wildcard..

    For example, to search for CARTON:
    set @col_name ='%carton%'
     
  6. Next, indicate whether you want the script to search TABLES OR search VIEWS (yes... views too!). To do this, set the @structure variable to either 'U' for TABLES or 'V' for VIEWS.

    For example, to search in tables:
    set @structure = 'U'
     
  7. Execute the script.
     

Now, the resulting list may not be 100% complete due to varying naming convention of the column name but the script does provide you with a good starting point


Screen shot of the script

Sqlscript


Screen shot of the results:
Sqlscriptresults


Dave currently works out of the New York office of Synergy Resources and can be reached there or via the Visual Manufacturing International User Group (VMIUG) under the handle dave_giusto.

 

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a01053702bb53970c0134872ba0b6970c

Listed below are links to weblogs that reference Searching all the tables that reference a particular data field (column name) :

Comments

Feed You can follow this conversation by subscribing to the comment feed for this post.

The comments to this entry are closed.

WHO IS VISUALNUGGETS?

Richard Ferlatte
Results Driven VISUAL Specialist

VISUAL WEBINARS - Updated!

Check out our 50+ Training Webinars focusing on the various VISUAL modules and concepts. There's sure to be one to interest you!
24 Manufacturing Webinars
15 Quality Webinars
13 Financial Webinars

VISUAL EXTENSIONS

Extend the functionality of your VISUAL ERP system with these proven and supported VISUAL apps
VE Mobile
The premier mobile extension to the VISUAL, adding flexibility and productivity improvements through the introduction of mobile scanning technology to the warehouse.
Logicity™ Automatic Invoicing
Automatically generate e-mailed or printed invoices out of VISUAL
EDI Integrator
A powerful alternative to the VMDI interface for EDI transactions (inbound and outbound).
Price Adjuster
Mass update routine for adjusting customer pricing
Credit Card Automation
Integrating credit card processing and fund capture directly with VISUAL.
Web Store Integration
e-Commerce solution integrating the web to your VISUAL system.