>Thanks. Really I'm going agaisnt syscolumns and not the actual tables for that data.
I'm confused. Are you looking to change the datatype from decimal(20,0) to decimal(38,9)? I don't think you can do it be changing syscolumns.
Now, if you want to find the tables that need to be modified, try using information_schema.columns.
-Mike
>
>>It wouldn't be an UPDATE, it would be an ALTER TABLE.
>>
>>-Mike
>>
>>>In our DW we are takinging gobs of Oracle data. Initial DTS package has Numeric fields as 20,0 and we are loosing some signifigant digits. Oracle Data Expert
wants us to have then Numeric 38,9
>>>
>>>I was going to create a script to determine what columns and what tables needed attention. Question --- finaly got here -- Can I create an update STATEMENT or do I have to make a change script?
>>>
>>># of tables in this DB, 180.
>>>
>>>__Stephen