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

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

 

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