Re: object question

Thanks for your help!

John

Francis Wong wrote:

> I saw from the documentation saying that you cannot define primary key or
> unique constraints on a column defined as 'ref'. Is it true? Anyway I tried
> to create a unique index on that column and it works.
>
> <maaher_at_my-deja.com> wrote in message news:8jffa9$4us$1_at_nnrp1.deja.com...
> > In article <Dhw65.30343$7I1.545495_at_news1.rdc2.on.home.com>,
> > "Francis Wong" <wongfrancis_at_home.com> wrote:
> > > I create a table using the following command:
> > >
> > > create table xxxxx (
> > > client_info ref client_objtyp scope is client_objtab
 not null,
> > > ...
> > > ...
> > > );
> > >
> > > However, I know that client_info is also unique in the table xxxxx.
 How can
> > > I put a constraint to make the column unique?
> > >
> > >
> > Hi Francis,
> > this is the SQL-command to add an unique constraint:
> > alter table xxxx
> > add constraint unq_cl_info UNIQUE(client_info);
> >
> > hope it helps,
> > Maarten
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Fri Jun 30 2000 - 00:00:00 CDT