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.
================================================
