Which of the following is NOT true about the TRUNCATE TABLE command?
A. Removes all records from the table.
B. Resets the identity column to the seed of the column.
C. Delete triggers are executed.
D. It cannot be used on tables referenced by foreign tables.
Answer:[C]
Highlight to find out the answer.
Tuesday, February 23, 2010
TRUNCATE TABLE
at 2:10 AM
Labels: SQL Server, SQL Server Test, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment