To drop a replicated table, follow these steps:
Use the Transact-SQL drop table command to drop the table at the primary database.
See the Adaptive Server Enterprise Transact-SQL User’s Guide for drop table syntax.
Use drop subscription to drop the subscriptions to the table. See “Using the drop subscription command”.
Use check subscription to confirm that the subscriptions are dropped. See “Using the check subscription command”.
Use drop replication definition to drop the replication definition to the table at the primary Replication Server. See “Dropping replication definitions”.
Use rs_helprep to confirm that the replication definition is dropped at all Replication Servers in the replication system. See “Viewing existing replication definitions”.
