Brad, Try following: SEL T1.SYS_TABLE_ID, + T2.SYS_TABLE_NAME,T1.SYS_COLUMN_NAME,T1.SYS_TYPE_NAME + FROM SYS_COLUMNS T1, SYS_TABLES T2 WHERE T1.SYS_TYPE_NAME = 'NOTE' AND T1.SYS_TABLE_ID=T2.SYS_TABLE_ID AND + T2.SYS_TABLE_TYPE='TABLE'
-- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- Brad Davidson <[EMAIL PROTECTED]> wrote: > 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/
