Removing tables from a publication (removetablesfrompub) v7
The removetablesfrompub
command removes tables from a publication.
Synopsis
See Removing tables from a publication for more information.
Note
The schema names, table names, and view names that you supply as values for the tables and views parameters are case sensitive. Unless quoted identifiers were used to build the database objects, you must use uppercase letters for Oracle names (for example, EDB.DEPT
) and lowercase letters for EDB Postgres Advanced Server names(for example edb.dept
). See Quoted identifiers and default case translation for more information.
Parameters
pubname
The name of the publication from which to remove tables or views.
pubsvrfile
The file containing the publication server login information.
schema_tn
The name of the schema containing the nth table of the tables parameter list. This value is case sensitive.
table_n
The name of the nth table in the tables parameter list. This value is case sensitive.
schema_vn
The name of the schema containing the nth view of the views parameter list. This value is case sensitive.
view_n
The name of the nth view in the views parameter list. This value is case sensitive.
Examples
This example removes the table edb.jobhist and view edb.salesemp
from the analysts_managers
publication.
- On this page
- Synopsis
- Parameters
- Examples