At 09:12 PM 4/9/2012, Michael J. Sinclair wrote:
When I do a a LIST command at the R>, it shows that I have some foreign
tables based on a database that I must have created long ago. For example....
todo0_dup 7 SERVER Server table - todo0 NOTEGENDB
How do I get rid of the connection to the NOTEGENDB database and get rid
of the tables? I looked in the ODBC driver window in the control panel,
and I don't see anything called NOTEGENDB
Here's how:
01. CONNECT dbname
Database Explorer | Main Menu | Utilities ...
Detach SQL Database Tables ...
Highlight appropriate table(s) and DROP 'em accordingly.
Database Explorer | Main Menu | Utilities ...
Disconnect SQL Data Source ...
Highlight appropriate tables and drop 'em accordingly.
02. You may also use the following commands at the R> prompt to achieve
the same goal:
SDETACH ALL NOCHECK
SDISCONNECT NOTEGENDB
03. DISCONNECT
04. CONNECT dbname
LIST TABLES
05. You may also use the UNLOAD ... RUN unloadfilename.ext technique
to clean the database structure/data, if you wish.
That's all there is to it!
Very Best R:egards,
Razzak
