SQL Server Drop命令取消 [英] Sql Server Drop command Cancellation

问题描述

如果我在执行sql server的过程中取消drop命令，表会发生什么情况

what happen to table if i cancel the drop command in the middle of execution in sql server

推荐答案

目前尚不清楚您要取消的确切含义，但是如果您取消了该命令，它将回滚，并且看起来该表什么都没有发生.
但是，如果您没有及时取消它(这很容易发生，因为drop是一个快速命令)，那么您就不必寻找备份...

It''s not clear how you exactly mean to cancel, but if you did cancel the command than it will roll-back and looks like nothing happened to the table.
But if you didn''t canceled it in time (which can happen very easily, as drop is a quick command), than you have to look for your backup...

这篇关于SQL Server Drop命令取消的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！