在SQL中重新創建表是否刪除其內容? - Does recreating a table in SQL erase its contents? -开发者知识库

在SQL中重新創建表是否刪除其內容? - Does recreating a table in SQL erase its contents? -开发者知识库,第1张

Just a real quick question. When modifying a table's columns, and saving requires table recreation, does recreating it erase all of its contents?

只是一個簡單的問題。在修改表的列時,保存需要表游憩,是否重新創建它將刪除所有內容?

Thanks in advance.

提前謝謝。

3 个解决方案

#1


2  

@gman4455 and @Erik .. yes it will erase the data but when you are adding it from SSMS it will take are of eveything .. you dont need to worry about the data .. SSMS will hold data temprory and when it recreates the table it will recreate the data for you.... so you dont need to worry about anything when you modifying a table's columns, and saving through SSMS

@gman4455和@Erik . .是的,它會擦除數據,但是當你從ssm中添加它時,它將會是eveything。你不需要擔心數據。地對地導彈將數據temprory當它再現了表將創建數據為你....因此,當您修改表的列並通過ssm保存時,您不需要擔心任何事情。

最佳答案:

本文经用户投稿或网站收集转载,如有侵权请联系本站。

发表评论

0条回复