Re: ALTERING A TABLE

Ron Peterson wrote:
>
>
> You can't use ALTER TABLE to change a field's data description.  You'll
> have to make a new table.  Then use SELECT INTO to move your data.  Then
> DROP TABLE oldtable.  Then ALTER TABLE tablename RENAME TO newname.

Would this really work?  According to the docs, SELECT INTO creates a
new table (which must not yet exist).  So this new table
would have the same field data descriptions as the original, right?

Is the documentation wrong?
--
Steve Wampler-  SOLIS Project, National Solar Observatory
swampler@noao.edu