Re: Adding/modifying columns

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Tue, 22 Jun 1999 03:44:53 GMT
Message-ID: <37800553.13243903@netnews.worldnet.att.net>

On Mon, 21 Jun 1999 12:59:02 +0000, Sam Jordan <sjo_at_spin.ch> wrote:

>What's the easiest way to add/modify columns in a table,
>if new constraints should be added, too?

alter table XXXX

    add (column_name varchar2(23),

            some_id   number,
            constraint fk_some_id 
               foreign key
               references YYYYY);

The above should work. XXXX and YYYY are table names.

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are          Received on Mon Jun 21 1999 - 22:44:53 CDT