Advertisement
Guest User

Untitled

a guest
Jul 19th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT S.RDB$FIELD_NAME
  2. FROM RDB$INDICES I
  3. LEFT JOIN RDB$INDEX_SEGMENTS S
  4. ON I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
  5. LEFT JOIN RDB$RELATION_CONSTRAINTS C
  6. ON C.RDB$INDEX_NAME = I.RDB$INDEX_NAME
  7. WHERE C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  8. AND C.RDB$RELATION_NAME = 'VENDA'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement