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