Oracle doesn't really have a INFORMATION_SCHEMA, but it has numerous tables
in the data dictionary that do the exact same thing if not more.


Gabriel


-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: October 16, 2003 8:41 AM
To: CF-Talk
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