Re: object question

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 Thu Jun 29 2000 - 00:00:00 CDT