Well...duh, I knew that. I guess old habits die hard. Javier,
Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, June 11, 2014 10:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Finding Column and Associated Table(s) - (was Re: DataDesigner Question) At 11:02 AM 6/11/2014, Javier Valencia wrote: >Try running the command: > >BROWSE * FROM SYS_COLUMNS > >And click on the SYS_COLUMN_NAME header to sort the columns >alphabetically and then find you columns name. If there is only one >occurrence then you are back to square one; however, I am guessing that >you might find more than one in which case you can make a note of the >matching SYS_TABLE_ID. >Run the command: > >BROWSE * FROM SYS_TABLES > >Click on the header of the SYS_TABLE_ID columns to sort it and the find >the table ids and the corresponding tables names and you might find a >duplicate columns name on the second table or view you forgot you had. Did you know that you can use the following command to find the list of all tables, including TEMPORARY TABLE(s), if any, for any given column name? LIST COLUMN colname Using this command will provide you with a comprehensive list of all tables, including the temporary table(s), associated with that column along with any CONSTRAINTS (NOT NULL, PK, FK, NOT NULL AUTONUMBER, INDEX, COMPUTE, etc.), if defined. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! -- --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
