Cannot delete from sys.tables
Posted
by
Shimmy
on Stack Overflow
See other posts from Stack Overflow
or by Shimmy
Published on 2011-01-10T01:32:56Z
Indexed on
2011/01/10
1:54 UTC
Read the original article
Hit count: 311
How can I perform this query on whatever way:
delete from sys.tables where is_ms_shipped = 0
What happened is, I executed a very large query and I forgot to put USE directive on top of it, now I got a zillion tables on my master db, and don't want to delete them one by one.
UPDATE: It's a brand new database, so I don't have to care about any previous data, the final result I want to achieve is to reset the master db to factory shipping.
© Stack Overflow or respective owner
