Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
phanlawi
Starting Member
1 Post |
 Posted - 2010-08-05 : 06:50:34
|
| I am very new to SQL server and i am not really good at it.I wanted to delete one table dbo (dbo.xxx) I used DROP and it seems to be successfully executed but when i restart the sql server again, the dbo.xxx is still sitting the database.Can somebody provides me with the info? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-05 : 07:32:27
|
DROP should give you an error message if the table cannot be dropped. perhaps whatever tool you are using is not showing you the error message?You cannot drop a table that has a Foreign Key relationship with a Child Table. And you cannot drop a table if you don't have permission  . and maybe, just maybe, something else is detecting the the table has been dropped and silently recreating it. Or maybe you DROPped it in a Transaction, and the Transaction was then rolled back.But other than that I don't think there are reasons why your DROP would have failed. |
 |
|
|
|
|
|
Delete dbo.XXX