Re: SQL DB
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/05/04
- Previous message: William: "SQL DB"
- In reply to: William: "SQL DB"
- Next in thread: William: "Re: SQL DB"
- Reply: William: "Re: SQL DB"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Jul 2004 18:45:41 +0530
Hi,
Are you trying to delete the data from table or remove the database fully.
Command to remove database. (Can anyone tell me the function that will
allow me to delete my current db?)
alter_database <dbname> set single_user with rollback immediate
go
drop database <dbname
or
from Enterprise manager .. Expland databases.. Select database.. Right click
and Delete
command to delete data from table (I need to delete all JobId's from the
db.)
See
DELETE command in books online.
-- Thanks Hari MCDBA "William" <anonymous@discussions.microsoft.com> wrote in message news:267dd01c46292$c42c95a0$a501280a@phx.gbl... > G'Day folks, > > My question is related to deleting an existing db in sql. > > The reason why I need to delete the existing db in sql is > to update the db from my log file. > > Example for the table jobs, I need to delete all JobId's > from the db. > > Can anyone tell me the function that will allow me to > delete my current db? > > Sincerely your's.
- Previous message: William: "SQL DB"
- In reply to: William: "SQL DB"
- Next in thread: William: "Re: SQL DB"
- Reply: William: "Re: SQL DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
