econz icon

Firebird - Retornar Campos da Chave Primária de Uma Tabela

econz | PRO | 05/15/15 11:35:44 AM UTC | 0 ⭐ | 863 👁️ | Never ⏰ | []
SQL |

250 B

|

None

|

0 👍

/

0 👎

SELECT
   S.RDB$FIELD_NAME
FROM RDB$INDEX_SEGMENTS S
LEFT JOIN RDB$RELATION_CONSTRAINTS RC ON (RC.RDB$INDEX_NAME = S.RDB$INDEX_NAME)
WHERE
   RC.RDB$RELATION_NAME = 'PESSOA' -- Coloque aqui o nome da tabela
   AND RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'

Comments