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]
- OT: max length of a fieldname Jill Robin Pascua
- Re: OT: max length of a fieldname Jochem van Dieten
- Re: OT: max length of a fieldname Deanna Schneider
- Gabriel Robichaud