>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.