Re: add

From: las <remove>
Date: Fri, 4 May 2001 13:00:39 +0100
Message-ID: <b_vI6.3846$Ty6.71298@news1.oke.nextra.no>

Thanks for your reply, I did "alter table client add age(int); and got invalid datatype error. What gives.

las

"Pavel Khakhaev" <pvh65_at_mail.ru> skrev i melding news:EC0DB93033E9D411B47100A0C945C0793A6EB4_at_exchange.stinol.int...
>
> "las" <laasunde_at_online.no> wrote in message
> news:GSsI6.3779$Ty6.70500_at_news1.oke.nextra.no...
> > I've got a table called "client" with the following fields :
> > name,address,city,country
> > How can I add a field, say "age" to this table with out deleting and
> > re-creating the table ?
> >
> > Thanks
> >
> > las
> >
> alter table CLIENT add AGE(datatype);
> Pavel
>
>
Received on Fri May 04 2001 - 07:00:39 CDT