Programmatically Change Column's Numeric Scale

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

Can someone show me the proper syntax to change the "Scale" property on a
column, preferably using ALTER COLUMN syntax?

Right now, the column is defined as Decimal with a precision of 8 and Scale
of 0. I want to change the Scale value to 4.

Thanks very much!
John
 
Try:
CurrentProject.Connection.Execute "ALTER TABLE MyTable ALTER COLUMN
MyDecimal DECIMAL(8,4);"

You're a brave man trusting this data type in JET though.
 
Back
Top