Board index » delphi » Getting Table names and Field names.

Paul Linehan

Delphi Developer
Mon, 26 Sep 2005 23:35:39 GMT

Getting Table names and Field names.

Hi all,

Quick question about Table names and Field names.

Select RDB$Relation_Name From RDB$Relations
where RDB$Flags = 1

will give me the names of my tables in a db.

How do I get the names of the Fields in a given table?

TIA.

Paul...

--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

 
Paul Lineha

Delphi Developer
Mon, 26 Sep 2005 23:38:37 GMT

Re:Getting Table names and Field names.


p...@not.a.chance.ie says...

Quote
> How do I get the names of the Fields in a given table?

Select RDB$Field_Name from RDB$Relation_Fields
where RDB$Relation_Name = 'MyRelationName'

Paul...

Quote
> Paul...

--

plinehan__AT__yahoo__DOT__com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04

Other Threads

1. Getting table names without prompt from user name and password

2. Delphi is case sensitive with Oracle table names and fields name

3. Last name, First name versus First name Last name

4. Getting the names of fields of a table

5. Getting User names and Computer names

6. Getting a DB name from an Alias name

7. ADO SQL build Index and test for unique [First name], [Middle name], [Last name]

8. How to get the table name or view name in a TADODataset

9. missing query, table name or procedure name

10. missing query, table name or procedure name???