Skip to main content
March 5, 2008
Question

SQL ALTER TABLE Question

Hi,

I'm fine changing the field type on a single field using the following sql:

ALTER TABLE #TP#_TemporaryTable
ALTER COLUMN Price double

I need to change multiple field types, can this be done in a single sql statement. I've tried

ALTER TABLE #TP#_TemporaryTable
ALTER COLUMN Price double
ALTER COLUMN UPC double

and a few others, but no luck. Is it possible to do this?

Thanks!

cfwild
Ce sujet a été fermé aux réponses.

2 commentaires

Inspiring
March 6, 2008
I tend to doubt MS Access would suppport it. But I am more familiar with other databases, than MS Access. So again your best bet is to check the MS Access documentation.
Inspiring
March 6, 2008
I imagine that would depend entirely on which database you are using. My guess would be no, but your best bet is to check the documentation for whatever database you are using.
March 6, 2008
Database is MS Access.

cfw