Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S

SDETACH (Short Name: SDE)

Scroll Prev Top Next More

Use the SDETACH command to remove a foreign data source table from a connected R:BASE database.

 

SDETACH

 

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`