SQL 面接の質問と回答
Question: What is the difference between TRUNCATE and DELETE commands?Answer: TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server.DELETE is a DML command and can be rolled back. Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster. |
復習用に保存
この項目をブックマークに追加したり、難しい内容としてマークしたり、復習セットに入れたりできます。
役に立ちましたか? はい いいえ
ユーザー評価で最も役立つ内容: