Advertisement
econz

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

May 15th, 2015
367
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.25 KB | None | 0 0
  1. SELECT
  2.    S.RDB$FIELD_NAME
  3. FROM RDB$INDEX_SEGMENTS S
  4. LEFT JOIN RDB$RELATION_CONSTRAINTS RC ON (RC.RDB$INDEX_NAME = S.RDB$INDEX_NAME)
  5. WHERE
  6.    RC.RDB$RELATION_NAME = 'PESSOA' -- Coloque aqui o nome da tabela
  7.    AND RC.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement