SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To mark a table as unavailable for SQL Remote replication.
sp_remove_remote_table table_name
| Argument | Description |
|---|---|
| table_name | The table to be marked as not available for SQL Remote replication. |
sp_modify_remote_table procedure
Marks a table as unavailable for replication. Once this procedure has been called, the data in the table cannot be shared with other databases using SQL Remote.
The following statement marks the employee table as unavailable for replication:
sp_remove_remote_table employee go