Roberto,

Try

ALTER TABLE <tablename> DROP CONSTRAINT <pkconstraintname>;

If you don't know the name of your primary key constraint
you can obtain it by

SELECT RDB$CONSTRAINT_NAME FROM RDB$RELATION_CONSTRAINTS
WHERE RDB$RELATION_NAME='<tablename>' AND
RDB$CONSTRAINT_TYPE='PRIMARY KEY';

Regards,
Mikko

> -----Original Message-----
> From: ext Roberto de Amorim [mailto:rbamorim@...]
> Sent: 04 January, 2002 01:52
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Changing the primary key
>
>
> hi all,
>
> I have a single table with no relationship and now I want to
> take out one
> field from Primary Key... so, is there anyway to do it
> without recreate the
> table?
>
> TIA
>
> Roberto de Amorim
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Tiny Wireless Camera under $80!
> Order Now! FREE VCR Commander!
> Click Here - Only 1 Day Left!
> http://us.click.yahoo.com/WoOlbB/7.PDAA/ySSFAA/dpFolB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>