>I have one customer who has a problem with a database changing structure. The structure changes from N(10,3) to to N(10).
>
>Is there a command to check the precision of the field and change it using alter table Alter Column ?
>
>Don
You can get precision of the field using AFIELDS() function (4th item of the array). What exactly is the error you're getting?
-------
From the Help to Alter Table command:
ALTER TABLE might rebuild the table by creating a new table header and appending records to the table header. For example, changing the type or width of a field can cause the table to rebuild.
If it's not broken, fix it until it is.
My Blog