Use the SDETACH command to remove a foreign data source table from a connected R:BASE database.
Options
,
Indicates that this part of the command is repeatable.
ALL
Specifies all tables.
ALL EXCEPT tblname
Specifies all tables except those specified.
NOCHECK
Eliminates the confirmation message.
tblname
Specifies the table to detach.
For information on how to attach foreign data source tables, see SATTACH.
Examples:
Example 01:
Detaches the tOrderDetails foreign table, without displaying the confirmation dialog
SDETACH tOrderDetails NOCHECK
Example 02:
Detaches all foreign data source tables except ServerFreight and ServerShipping
SDETACH ALL EXCEPT ServerFreight, ServerShipping
Example 03:
Detaches the dbo.Orders foreign table, where IDQUOTES are used as the name contains a period
SDETACH `dbo.Orders`