Home
About Us
Contact Us
Bookmark
Saved Bookmarks
Current Affairs
General Knowledge
Chemical Engineering
UPSEE
BSNL
ISRO
BITSAT
Amazon
ORACLE
Verbal Ability
→
Sql Server Architect Tutorial
→
Sql Server Architect Interview Questions in Sql Server Architect Tutorial
→
Explain The Truncate Command?
1.
Explain The Truncate Command?
Answer»
Truncate command is used to
REMOVE
all
ROWS
of the column.
The removed records are not
RECORDED
in the
TRANSACTION
log.
It is the fast way to remove all the records from the table.
The records once removed can’t be rolled back.
It can’t
ACTIVATE
trigger.
It resets the identity of the column.
Show Answer
Discussion
No Comment Found
Post Comment
Related InterviewSolutions
Explain The Truncate Command?
Explain The Microsoft Sql Server Delete Command?
Explain What Are The Restrictions That Views Have To Follow?
What Is Master Database?
Do You Know What The Restrictions Applicable While Creating Views Are?
What Is Msdb Database?
What Is The Difference Between Cube Operator And Roll Up Operator?
What Is Temp Db Database?
Explain Logical Database Components?
What Is Model Database?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply
Your experience on this site will be improved by allowing cookies. Read
Cookie Policy
Reject
Allow cookies