Brad Use the SYS_TYPE_NAME column of the SYS_COLUMNS table.
David Blocker ----- Original Message ----- From: "Brad Davidson" <[EMAIL PROTECTED]> To: "Rbase List Questions" <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 1:08 PM Subject: Finding Columns by Data Type > Want to find all column & table name associations by data type. Have > tried a tally: > tally sys_data_type from sys_columns, > but result is listing of integers from -6 to 14. Assuming numbers > represent data type? Looking for all columns where data type is NOTE. > Any direction on this appreciated. > > Thanks, > Brad > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
