## SQLWays - Importing Tables

This chapter describes importing tables to the target database using SQLWays.

- Importing tables that already exist in the database

### Importing tables that already exist in the database

Tables that you import may already exist in the target database. For example, tables might be created by another tool and you use SQLWays to import data only. Or you perform the migration process several times, and after first migration all tables exist in the target database.

In this case, you may want to drop tables before importing them again.

SQLWays has the option to generate the DROP TABLE statement before each CREATE TABLE statement. This option allows you to drop the table before re-creating it.

To generate the DROP TABLE statement

- SQLWays Wizard - DDL Options Page
- SQLWays command prompt - [DDL] Section

Executing a DROP TABLE statement in some databases you may face a problem that the table cannot be dropped. For more information see, Dropping Tables

[Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.