If you want to designate a different identifier or owner for the destination table, you can specify the RENAME clause of MOVE TABLE. If the destination database already has that identifier registered for any table, view or synonym, MOVE TABLE fails and returns an error. Also, if the new owner specified in this clause is an existing role name in the destination database, MOVE TABLE fails and returns an error. The RENAME clause that also specifies a new owner name does not change owner of the table objects, such as indexes or constraints. MOVE TABLE maintains the original owners of those objects after the table has moved. That is, the RENAME clause renames only the table, and not its objects.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]