What is the difference between truncating a table and dropping a table?


When a table is truncated, the table structure remains, but the data stored in the table are removed. When a table is dropped, both the table structure and the data contained in the table are permanently deleted.

Business

You might also like to view...

When depreciation estimates are revised, all years of the asset's life are affected

a. True b. False Indicate whether the statement is true or false

Business

In the relational database model

a. relationships are explicit b. the user perceives that files are linked using pointers c. data is represented on two-dimensional tables d. data is represented as a tree structure

Business

One of the four dimensions that intractable conflicts vary along is ________-the level of participant involvement, emotionality, and commitment in a conflict.

Fill in the blank(s) with the appropriate word(s).

Business

Which of the following would be an irrelevant cost?

A) Future costs that differ among alternatives. B) Benefits foregone by choosing one alternative over another. C) Costs that have already been incurred. D) Costs that are avoidable.

Business