DelphiFAQ Home Search:

Enumerating user tables in an InterBase database

 

comments3 comments. Current rating: 3 stars (2 votes). Leave comments and/ or rate it.

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!

Comments:

2012-09-29, 20:06:46
 
rating
zaumdmi <a href=' http://ukpaydayloansfh.co.uk/ '>Quick Quid</a> 7961 <a href=' http://uspaydayloansfh.com/ '>payday loans</a> >:-OOO <a href=' http://canadapayday..oansta.ca/ '>payday Canada</a> %-[[[
2013-02-07, 09:56:00
 
rating
zyltcvj <a href=' http://paydayloansvbb.co.uk/ '>payday loans</a> 1218 <a href=' http://paydayloansvbb.com/ '>payday loans</a> >:-[ <a href=' http://paydayloansvbb.ca/ '>payday loans</a> zpfQY
2015-01-30, 01:41:41
anonymous from Iran  
I acquired more new thnigs on this fat loss issue. One issue is a good nutrition is especially vital while dieting. A massive reduction in junk food, sugary food, fried foods, sweet foods, beef, and white-colored flour products could possibly be necessary. Holding wastes parasitic organisms, and wastes may prevent targets for losing fat. While specific drugs quickly solve the issue, the horrible side effects are usually not worth it, and so they never offer more than a short-term solution. This is a known fact that 95% of celebrity diets fail. Thanks for sharing your ideas on this web site.

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: