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 DBISQLin System Administration Guide: Volume 1. 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 Reference: Statements and Options.