Board index » delphi » Field Names

Field Names

Hello Guys,

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

Sds,

Marcelo Duraes da Silva

 

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

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