How to get the name of fields ?

[Fábio Pinheiro]

does anybody know to get the name of the fields for a table, without
needing to use the tables and views of the system?

Fábio Pinheiro

[Jason Cumberland]

The only method I know to get this information is from the INFORMATION_SCHEMA system views, an example query is below.

select * from information_schema.columns where table_name = 'yourtablenamehere'

--
Jason
:wq

[Fábio Pinheiro]

ok, this way i know too.
I need a solution for any database server (oracle, sql-server, postgre,
firebird, etc...)
anybody knows ?

Jason Cumberland escreveu:

> The only method I know to get this information is from the
> INFORMATION_SCHEMA system views, an example query is below.
>
> select * from information_schema.columns where table_name =
> 'yourtablenamehere'
>

> On 11/14/06, *Fábio Pinheiro* <fcpin...@gmail.com