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.
Registrovani: 88 ( Alkibijad, Zoranche, zagizoe, ppeky, Parsifal, digitalsat, Buum, varelg, Miroslav Jeftić, MobyX, blocker, bttp, zorann3, optix, bobe84, []-_-[], Jorgovan88, savcic, metju, angelos, Catch 22, bodhi, mikica111, lm741, Shmeker1, roppe, virtualx, djolepiv, micopop, hiphop28, nhordez, vladdy, alpeko, zaraza, vlax352, apex, -V-O-Y-A-G-E-R-, dEXE, Džeronimo, Dr Boca, vedranb, Bik Koji Sedi, Danijel83, kiselilimun, jocadejan, .qwerty., sasa15, lord_celtic, Jovan Prokopović, elite84, Aleksandar Ružičić, joeya1k, Milan Ogrizovic, SmilieBG, germanchc, Marko_L, nvidojkovic, DJ_IGGY, GadGet, goran_67, Fuzz, NS85m, maxxex, vojailic, Nebojsa Milanovic, scroll, ventura, rjovica, guja011, snake_master, jsmith, calexx, Predrag Supurovic, DzoA, Nemanja1990, bordoris, blasko15, nemysis, zoltv, jocho, easyyu, Brain raider, Darko R, Radisha, bojanlazovic, miki069, vjakov, zeoN_Rider )
Foreign key i referenciranje tabele