Monday, March 5, 2007
Tip of the Day: Using Enhanced DROP ALL Command
Supported Versions:
. R:BASE 7.6 for Windows (Build: 7.6.1.30301 or higher)
. R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30301 or higher)
. R:BASE Turbo V-8 for Windows (Build: 8.0.15.30301 or higher)
Typically, the DROP ALL TABLES command can be used to DROP all
tables with a warning dialog prompt (Yes/No) to verify each
table and DROP ALL VIEWS command can be used to DROP all views
with a warning dialog prompt (Yes/No) to verify each view.
However, if you wish to DROP ALL tables except a few, you may
use the DROP ALL TABLES EXCEPT tablename1, tablename2 command.
You may also use the *enhanced* DROP ALL VIEWS EXCEPT viewname1,
viewname2 command using the latest versions/updates of R:BASE.
Summary:
. Use DROP ALL or DROP ALL TABLES command to drop all TABLES
. Use DROP ALL VIEWS command to drop all VIEWS
. Use DROP ALL TABLES EXCEPT listoftables command to drop all
tables except the ones listed, separated by commas
Example:
DROP ALL TABLES EXCEPT tablename1, tablename2
. Use DROP ALL VIEWS EXCEPT listofviews command to drop all
views except the ones listed, separated by commas
Example:
DROP ALL VIEWS EXCEPT viewname1, viewname2
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.
================================================
