Re: geting Table definition ?

Select
  column_name,
  datatype
FROM
  user_tab_columns
WHERE
  table_name = UPPER(<your table name>);

Mark

In article <895quh$64h$1_at_news.netway.at>, "Christoph Skladal" <c.skladal_at_kba.at> wrote:
>Hello,
>
>can I get the list of the fields from a table with SQL-
Command ?
>
>Thanks
>
>regards
>
>Christoph Skladal
>
>
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!