Check out the ALTER TABLE command.
alter table xxx add ( colxxx datatype)
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sted Alana" <Sted_Alana_at_hotmail.com> wrote in message
news:3cd7cb00_1_at_news.iprimus.com.au...
> Consider a table foo, how do i add a column named fieldfoo1 to it?
>
> im not sure but i believe it has something to do with update followed by
an
> alter.
>
> Any help appreciated.
>
>
> --
> N e w s N e t C u s t o m e r
> E - m a i l : sted.alana_at_hotmail.com
>
>
>
>
>
>
Received on Mon May 13 2002 - 16:10:39 CDT
