Skip to main content
March 5, 2008
Question

SQL ALTER TABLE Question

  • March 5, 2008
  • 2 replies
  • 630 views
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
This topic has been closed for replies.

2 replies

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