Re: Example of using ALTER to add columns

Michael Duke wrote:
>
> Could anyone show me an example of using ALTER to add
> columns to a table? Is it as simple as
>
> ALTER TABLE tablename
> rowname rowtype,
> rowname rowtype;
>
> Thanks in advance,
> Michael
> a10377_at_email.mot.comHi.

You are close. It is ALTER TABLE tablename

                         ADD (rowname  rowtype,
                              rowname  rowtype);

Hope this helps.
Dick Allie - dallie_at_ionet.net Received on Wed Apr 02 1997 - 00:00:00 CST