Dropping a Classic Replication Scheme
You can use the DROP REPLICATION
statement to remove a replication
scheme from a database. You cannot drop a classic replication scheme when master catchup is
required unless it is the only classic replication scheme in the database.
Note:
You must have the ADMIN
privilege to use the DROP REPLICATION
statement.
You must stop the replication agent before you drop a classic replication scheme.
To remove the repscheme
replication scheme from a database, enter the following:
DROP REPLICATION repscheme;
If you are dropping replicated tables, you must drop the classic replication scheme before dropping the replicated tables. Otherwise, you receive an error indicating that you have attempted to drop a replicated table or index.
To remove the tab
table and repscheme
replication scheme from a database, enter the following:
DROP REPLICATION repscheme; DROP TABLE tab;