Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_migrate_data system procedure Next Page

sa_migrate_drop_proxy_tables system procedure


Drops the proxy tables that were created for migration purposes.

Syntax

sa_migrate_drop_proxy_tables( i_table_owner )

Arguments
Remarks

This procedure drops the proxy tables that were created for the migration. The user who owns these proxy tables is specified by the i_table_owner argument.

If the migrated tables are not all owned by the same user on the target SQL Anywhere database, you must call this procedure for each user to drop all the proxy tables.

As an alternative, you can migrate all tables in one step using the sa_migrate system procedure.

This system procedure is used in conjunction with several other migration system procedures. The note in the Remarks section of the sa_migrate_create_fks system procedure contains the list of migrate procedures, and the order in which you must execute them. See sa_migrate_create_fks system procedure.

Permissions

None

Side effects

None

See also
Example

The following statement drops the proxy tables on the target SQL Anywhere database that belong to the user local_a.

CALL sa_migrate_drop_proxy_tables( 'local_a' );