Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > D

DETACH (Short Name: DET)

Scroll Prev Top Next More

Use the DETACH command to remove a dBASE file table and its associated dBASE index files from the open R:BASE database.

 

DETACH

 

Options

 

,

Indicates that this part of the command is repeatable.

 

ALL

Removes all dBASE tables and associated dBASE index files from the open R:BASE database.

 

ALL EXCEPT file_tblname

Removes all dBASE tables and associated dBASE index files from the open R:BASE database, except the specified table.

 

file_tblname

Removes the specified dBASE table and associated dBASE index files from the open R:BASE database.

 

NOCHECK

Eliminates the confirmation message.

 

About the DETACH Command

 

Before you can detach a dBASE file table, an R:BASE database must be open. When you detach a dBASE file table, do not include the .DBF extension. DETACH requires the database owner's user identifier if one has been defined.

 

If you remove a dBASE file that is used in a form, report, label, or application, make the necessary changes to reflect detaching the dBASE file from the database. The rules, descriptions, and any access rights are deleted when you detach the dBASE file.

 

Use ATTACH to reattach a detached file to the same or a different database.

 

When STATICDB is set on, which activates a read-only schema mode, DETACH is only available for dBASE tables that were attached in the read-only schema mode, which creates temporary dBASE tables.

 

Example

 

In the following example, the first command line opens the concomp database. The second command line detaches the dBASE file table sampgate from the concomp database.

 

CONNECT concomp

DETACH sampgate