a simple question how to drop a database with the use of IF stmt to check if the object exist.
if object_id('dbo.myDB') is not null
drop database 'myDB'
go
the code returns no error but it also wont delete the database("myDB")
|
Results 1 to 7 of 7
Thread: [RESOLVED] [sql 2k5] DROP TSQLThreaded View
|
Click Here to Expand Forum to Full Width |