Board index » delphi » Field Names

Marcelo Duraes da Silva

Delphi Developer
Sun, 29 Aug 2004 21:06:50 GMT

Field Names

Hello Guys,

How Can I list field names of a Table using SELECT statment?

Sds,

Marcelo Duraes da Silva

 
Marcio Barros

Delphi Developer
Mon, 30 Aug 2004 01:39:39 GMT

Re:Field Names


Hi Marcelo,

try this :

SELECT rdb$Field_Name
FROM     rdb$Relation_Fields
WHERE  rdb$Relation_Name = 'TABLE_NAME'

PS: Use the TABLE_NAME in upper case (maisculas)

Hope this helps,

Mrcio Barroso

Marcelo Duraes da Silva <marcelodur...@zaz.com.br> escreveu nas notcias de
mensagem:3c8f4e34$1_2@dnews...

Quote
> Hello Guys,

> How Can I list field names of a Table using SELECT statment?

> Sds,

> Marcelo Duraes da Silva

Marcelo Duraes da Silv

Delphi Developer
Mon, 30 Aug 2004 02:46:48 GMT

Re:Field Names


Thanks Marcio,

"Marcio Barroso" <desen...@dinamicasist.com.br> escreveu na mensagem
news:3c8f8e50_2@dnews...

Quote
> Hi Marcelo,

> try this :

> SELECT rdb$Field_Name
> FROM     rdb$Relation_Fields
> WHERE  rdb$Relation_Name = 'TABLE_NAME'

> PS: Use the TABLE_NAME in upper case (maisculas)

> Hope this helps,

> Mrcio Barroso

> Marcelo Duraes da Silva <marcelodur...@zaz.com.br> escreveu nas notcias
de
> mensagem:3c8f4e34$1_2@dnews...
> > Hello Guys,

> > How Can I list field names of a Table using SELECT statment?

> > Sds,

> > Marcelo Duraes da Silva

Other Threads

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

2. Getting Table names and Field names.

3. Access Fields with spaces in Field Names

4. filter for field containing spaces in the field name

5. Capturing Field Changes & Field Names

6. Help with using TQuery component with a Field name that has a space in field name.

7. Q: changing field name at runtime?

8. Retrieve table field names from query object

9. SQL Queries with Funny Field Names

10. Blanks in field names