Welcome to Sign in | Help

Drop Database

  •  12-07-2006, 9:34 AM

    Drop Database

    Raspunsurile voastre mi-au fost de mare ajutor. Merci
    Acum am o noua problema:
      Vreau, daca o baza de date exista sa o sterg si apoi sa o creez din nou. (un fel de clean-up)
    Foloseam urmatorul cod, dar nu merge daca baza de date nu exista.

    if exists(select * from sys.databases where name='pressurePotExciteDB')
    begin
    drop database [pressurePotExciteDB]
    end
    create database [pressurePotExciteDB]
    use [pressurePotExciteDB]

    Imi da urmatorul mesaj, daca baza de date nu exista:

    Msg 911, Level 16, State 1, Line 6
    Could not locate entry in sysdatabases for database 'pressurePotExciteDB'. No entry found with that name. Make sure that the name is entered correctly.




    Filed under:
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems