Re: alter table rename column

RENAME is not a valid argument with this statement (as far as I know) ...
you would have to add a new column, run an update to copy the data from
oldcolumn to newcolumn, then drop the old column.

-- 
Scott McDaniel
CS Computer Software
www.thedatabaseplace.net

"mharness" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> Can anyone tell me how to make this alter table command work?
>
> alter table tblprospects rename column telephone number to phone
>
> I've tried square brackets, parenthesis, single, and double quotes around
> telephone number and they all error out.
>
> Thanks, Mike
>
>