Monday, August 14, 2006
Did you know that the latest update of R:BASE 7.5
for Windows (Update 25), Build:7.5.25.30814, FRC2,
includes a few new LIST commands to list PRIMARY,
FOREIGN and UNIQUE Keys?
Here's how:
01. New LIST PKEYS Command
LIST PKEYS command will return a list of all
PRIMARY KEYs and PRIMARY KEYs REFERENCED.
02. New LIST PKEYS FOR tablename command
LIST PKEYS FOR tablename will return the name of
a PRIMARY KEY column for a given table name and
associated REFERENCED keys, if defined.
03. New LIST FKEYS Command
LIST FKEYS command will return a list of all
FOREIGN KEYs in the connected database.
04. New LIST FKEYS FOR tablename command
LIST FKEYS FOR tablename command will return a
list of all FOREIGN KEY columns for a given table,
if defined.
05. New LIST UKEYS Command
LIST UKEYS command will return a list of all
UNIQUE KEYs in the connected database.
06. New LIST UKEYS FOR tablename command
LIST UKEYS FOR tablename command will return a
list of all UNIQUE KEY columns for a given table,
if defined.
Enjoy and make sure to have fun!
Very Best R:egards,
Razzak.
--- 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.
================================================
