Script to Update Column Names to Standard Abbreviations

[Julian Bishop]

Hi,

Does anyone have a script that will run against the entire schema and update column names to a standard set of abbreviations. For instance, if my table contains a column called ACCOUNT_NUMBER the script would rename it to ACCT_NO based on a dictionary of abbreviations.

The script could contain the dictionary of abbreviations as an array (ACCOUNT = ACCT, NUMBER = NO, etc. etc.). There are probably no more than 300 abbreviations of interest.

Looks like this would be a fairly easy plugin to code - but I have no experience in coding GRT scripts. If someone could get me started in the right direction it would be greatly appreciated.

Thanks.