[FB 1.5][BCB5]Récuperer les champs de la clé primaire ? [Résolu]

[Sitting Bull]

bonjour,

Comment récupérer les champs faisant partis d'une clé primaire ?

[Sitting Bull]

Trouvé !!

Code :

1
2
3
4
5
6
7
SELECT rc.RDB$RELATION_NAME, rc.RDB$INDEX_NAME,
       i.RDB$FIELD_NAME
FROM RDB$RELATION_CONSTRAINTS rc, RDB$INDEX_SEGMENTS i
WHERE (i.RDB$INDEX_NAME = rc.RDB$INDEX_NAME)
  AND (rc.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY')
  AND (rc.RDB$RELATION_NAME = 'TBL_LISTFICH')
ORDER BY rc.RDB$RELATION_NAME, i.RDB$FIELD_POSITION