Database delete

Discussion in 'ASP.NET 2.0' started by sridhar.a, May 16, 2007.

  1. sridhar.a

    sridhar.a

    Hi
    I have upoladed one database, I tested. now I want to delete all the tables and upload
    again. how will I remove all my user defined tables from my database? not one by one,
    all at once.

    Thanks in advance
    Sri
     
    sridhar.a, May 16, 2007
    #1
  2. wisemx

    wisemx

    ...The methods differ, depending on which version you're using and the IDE on your end.

    You can DROP an entire database or individual tables.

    From the management IDE's in SQL Server 2000 and 2005 just right-click on the table names.
    You'll see the options.
    Once you have selected to drop a table just Execute the command.

    ...Only requires a few mouse clicks, no code or typing at all.
     
    wisemx, May 16, 2007
    #2

Share This Page