Deleting databases

You can use the DROP command in DBISQL to remove the database files (temporary files, Sybase IQ database files, and catalog files) for a database.

StepsDeleting a database

  1. Start the server without a database (the preferred method) or with a different database than the one to be dropped.

  2. Start DBISQL, if it is not already running. (For instructions, see “Connecting to other databases from DBISQL” on page 88 in Sybase IQ System Administration Guide.) If no database was specified, the utility database is used, and the Database Name must be set to utility_db.

  3. Type the following command:

    DROP DATABASE <DBname>
    

For more details about this command, see the Sybase IQ Reference Manual.