Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_remove_remote_table procedure

Purpose 

To mark a table as unavailable for SQL Remote replication.

Syntax 

sp_remove_remote_table table_name

Argument	Description
table_name	The table to be marked as not available for SQL Remote replication.

See also 

sp_add_remote_table procedure

sp_modify_remote_table procedure

Description 

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.

Example 

• The following statement marks the employee table as unavailable for replication:

  sp_remove_remote_table employee
  go