Unpublishes the specified database so that updates are no longer logged.

Syntax

---

UNPUBLISH DATABASE <DatabaseName>
[TABLES <TableName> [,<TableName>]]

Usage

---

Use this statement to unpublish the specified database so that any updates to the database tables are no longer logged. Once a database table has been unpublished using this statement, it will no longer be possible to save any logged updates to the table to an update file using the SAVE UPDATES statement.

The TABLES clause is optional and allows you specify a subset of tables from the database for unpublishing. The default behavior is to unpublish all tables in the database. If the specified tables, either via the TABLES clause, or all of the tables in the database, have been already unpublished, then this statement is essentially ignored.

You can publish a database using the PUBLISH DATABASE statement.

Please see the Replication topic for more information on loading/saving updates for a database.

Examples

---

-- This example unpublishes the Transaction
-- table in the Accounting database

UNPUBLISH DATABASE Accounting
TABLES Transaction

Required Privileges

---

The current user must be granted the MAINTAIN privilege on the current database in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: