za Tables:
Code:
SELECT
RDB$RELATION_NAME
FROM
RDB$RELATIONS
WHERE
RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NULL;
za Columns:
Code:
SELECT
RDB$FIELD_NAME
FROM
RDB$RELATION_FIELDS
WHERE
RDB$RELATION_NAME = 'TABELAX';
za Constraints:
Code:
SELECT
RDB$INDEX_NAME
FROM
RDB$INDICES
WHERE
RDB$RELATION_NAME = 'TABELAX' AND ( RDB$UNIQUE_FLAG IS NOT NULL OR RDB$FOREIGN_KEY IS NOT NULL );
vraća polja i tabele iz indeksa:
Code:
SELECT I.RDB$RELATION_NAME AS TABLENAME,
S.RDB$FIELD_NAME AS FIELDNAME
FROM RDB$INDICES I
LEFT JOIN RDB$INDEX_SEGMENTS S ON
(S.RDB$INDEX_NAME = I.RDB$INDEX_NAME)
WHERE (I.RDB$INDEX_NAME = 'IME_INDEKSA');
pogledaj još i sistemske tabele RDB$REF_CONSTRAINTS i RDB$RELATION_CONSTRAINTS i druge pa kombinuj i istestiraj.
Foreign key i referenciranje tabele
