[thelist] SQL question

Leo Wiedersheim leo_wiedersheim at hotmail.com
Wed Apr 4 10:00:38 CDT 2001


If you mean the max length of data in a field, this works in oracle:

select max(length(your_field_name)) from your_table_name;

hth,
Leo.


From: "Ryan Carmody" <carmodyryan at hotmail.com>
Reply-To: thelist at lists.evolt.org
To: thelist at lists.evolt.org
Subject: [thelist] SQL question
Date: Wed, 04 Apr 2001 10:53:36 -0400

Hi all,

Is there any way to find the length of certain or all fields in a table
using sql?  I need to set the maxlength for over 500 fields, dynamically.
If I had to hardcode it I could, but then if a new field is added I'd have
to go and set the maxlength.

TIA,
Ryan Carmody
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com





More information about the thelist mailing list