How to delete a table inside a database in your MSDE database?

The databases are located in the C:\MSSQL7\DATA directory with an "mdf" extension associated to a log file having a "ldf" extension. If you want to delete a table MYTABLE inside the testdb database, do the following:

(Make sure to use Uppercase character if Uppercase is required in the next command lines, such –U –P or -Q)

Open a DOS Windows

Go to the C:\MSSQL7\BINN directory

Type the command:

OSQL –U sa

Press <Enter>

You will be prompted to enter a Password:

Press <Enter>

You will receive a command line as follow:

1>

Write the command:

1> drop table testdb.dbo.mytable

Press <Enter>, you will receive a new command line:

2>

Write the command:

2> go

Press <Enter>

You will receive a message if the command is successful and the command line will come back to:

1>

Type the following command to quit:

1> Exit

Press <Enter>

You will come back to the prompt:

C:\MSSQL7\BINN