DROP DUPLICATE

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements >

DROP DUPLICATE

Use the DROP DUPLICATE statement to remove from the database all duplicate copies of a specified existing table that the CREATE DUPLICATE statement created in a specified dbslice or in specified dbspaces across coservers. The original table is not affected by the DROP DUPLICATE statement.

Only Extended Parallel Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-DROP DUPLICATE OF TABLE--+-----------+--table---------------><
                            '- owner--.-'

Element	Description	Restrictions	Syntax
owner	Owner of the duplicate table	Must own the duplicate table	Owner Name
table	Name of the table for which you want to remove all duplicates	Must exist and must be a duplicated table	Identifier

Usage

To drop all duplicate copies of a duplicated table and leave only the original table, enter the DROP DUPLICATE statement. Because duplicate tables are read-only, to update a duplicated table, you must first drop all duplicate copies.

Attached indexes on the copies of the duplicate table are also dropped when DROP DUPLICATE is successfully executed.

Related Information

CREATE DUPLICATE