| Subject | Getting the name of a primary key |
|---|---|
| Author | Carsten Schäfer |
| Post date | 2006-11-15T09:07:01Z |
I want to change the primary key of a table.
Can i get the name of the primary key with a select and can i use this
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) ?
mfg
Carsten
Can i get the name of the primary key with a select and can i use this
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) ?
mfg
Carsten