DelphiFAQ Home Search:
General :: Databases :: InterBase
Help with InterBase, Borland's open source database.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Enumerating user tables in an InterBase database

A list of user tables can be retrieved by querying system table rdb$relations.

The example below shows how to do this - it inserts the table names sorted alphabetically into a ListBox (lbSourceTables).

begin
   ibcSourceList.SQL.Clear;
   ibcSourceList.SQL.Add('select rdb$relation_name from rdb$relations');
   ibcSourceList.SQL.Add('where rdb$system_flag = 0');
   ibcSourceList.SQL.Add('order by rdb$relation_name');
   ibcSourceList.Open;
   while not ibcSourceList.Eof do
   begin
     lbSourceTables.Items.Add(ibcSourceList.Fields[0].AsString);
     ibcSourceList.Next;
   end;
   ibcSourceList.Close;
 end;
You don't like the formatting? Check out SourceCoder then!
Generated 20:00:34 on Sep 19, 2017