Thanks for your so clear answer! I tried it through( SQL query analyzer) and
it works.

I also found another way to delete the database: 
In SQL Query Analyzer window, I clicked Object Browser icon. I found the
database that I want to delete, highlighted it and deleted it.

I just bought "Beginning SQL Programming" book to practice SQL. The CD
inside the book doesn't include "Enterprise Manager" tool( there is submenue
for it but nothing happens when I clicked it.) I also hope to run DTS
designer. I am going to convert paradox database to SQL Server using MSDE
import/export data wizard. I met the folowing problems:

1. How to make desktop shortcuts for MSDE/Import/Export Data and SQL Query
Analyzer? From start menu, I located those submenus and tried right-click.
failed.

2. Since in original Paradox, primary key was not defined. I want to add
primary key for the destination table. I am going to
click Edit SQL button to do it. 


Zili

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Monday, August 13, 2001 7:26 PM
To: sql language
Subject: [sql_language] Re: how to delete database


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Zili Liu" <liu@Q...>
Subject: [sql_language] how to delete database


: Hello all,
:
: I created a database using DTS import/outport wizard. I wonder if anybody
: can tell me how to delete it. I know that the database is located in
: C:\mssql7\... I highlighted it and clicked delete but it doesn't work.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

You need to use DROP DATABASE, or delete it via the Enterprise Manager.
Look in Books Online for the syntax for DROP DATABASE.

You can't just delete the files on the disk, because:
a) SQL Server has a lock on them while the SQL Server service is running
b) There will still be references in the system tables in the Master
database, and you'll get errors when you start SQL Server next.

Cheers
Ken