Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How to Enumerate user tables in an InterBase database Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
Enumerating user tables in an InterBase database 25-Aug-02
Category
Database Others
Language
Delphi 2.x
Views
75
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Tomas Rutkauskas 

Enumerating user tables in an InterBase database

Answer:

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).

1   begin
2     ibcSourceList.SQL.Clear;
3     ibcSourceList.SQL.Add('select rdb$relation_name from rdb$relations');
4     ibcSourceList.SQL.Add('where rdb$system_flag = 0');
5     ibcSourceList.SQL.Add('order by rdb$relation_name');
6     ibcSourceList.Open;
7     while not ibcSourceList.Eof do
8     begin
9       lbSourceTables.Items.Add(ibcSourceList.Fields[0].AsString);
10      ibcSourceList.Next;
11    end;
12    ibcSourceList.Close;
13  end;


			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC