Re: geting Table definition ?

From: Christoph Skladal <c.skladal_at_kba.at>
Date: Mon, 28 Feb 2000 14:23:05 +0100
Message-ID: <89dsru$lk8$1@news.netway.at>

Hello Marc,

your Tip will only work with tables in Tablespace System but I have genarate a private Tablespace.

Have you a other Tip ?

Thanks

Christoph Skladal

"mgumbs" <mgumbsNOmgSPAM_at_hotmail.com.invalid> schrieb im Newsbeitrag news:1d79c3a0.c7c79e64_at_usw-ex0103-018.remarq.com...
> 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!
>
Received on Mon Feb 28 2000 - 07:23:05 CST