"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.

"William" <anonymous@discussions.microsoft.com> wrote in message
news:2684e01c4629a$63758bb0$a501280a@phx.gbl...
> Hello,
>
> What I want to do is delete all data found in jobs table
> because I need to update it by running a script on a log
> file.
>
> When i wrote your function it gave me a script error in
> the syntax in near '<'. Here's what i re-wrote:
>
> FROM Jobs alter_database < Jobs >
> SET single_user WITH ROLLBACK immediate go
> DROP DATABASE < Jobs >
>
> I also looked for the easier way which is by from
> Enterprise manager .. Expland databases.. Select
> database.. Right click
> and Delete, but I can't find Expland databases in
> Enterprise Manager.
>
> Can someone tell me where it is and tell why I'm not able
> to delete everything from Jobs table?
>
>
> Cheers!
>
>
>
>
> >-----Original Message-----
> >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.
> >
> >
> >.
> >