Subject | Re: [firebird-support] Getting the name of a primary key |
---|---|
Author | Ivan Prenosil |
Post date | 2006-11-15T10:58:24Z |
>I want to change the primary key of a table.Yes. Look at table RDB$RELATION_CONSTRAINTS
> Can i get the name of the primary key with a select
> and can i use thisNo.
> select to drop the primary key ?
> Like "alter table TEST drop constraint (select pk_name from ... where
> table_name like 'TEST')"
> Ist this possible (with FB 2.0) ?
Ivan
http://www.volny.cz/iprenosil/interbase/