Oracle 8i does not support information_schema. Not sure about 9i.

-d

----- Original Message -----
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 7:41 AM
Subject: Re: OT: max length of a fieldname

> Jill Robin Pascua said:
> > What'st he maximum length for fieldnames in MS SQL
> > Server and in Oracle?
>
> This should be in the INFORMATION_SCHEMA of the database:
>
> SELECT sizing_name, supported_value
> FROM   information_schema.sql_sizing
> WHERE  sizing_id = 30
>
> Not sure if Oracle supports an INFORMATION_SCHEMA, but MS SQL Server
> has one. You should check it out, it has a lot of information.
>
> Jochem
>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to