adspace


Can we rollback after truncate?

Answer Posted / Abhineet Sehgal

No, the TRUNCATE TABLE command does not support a rollback because it does not create undo records. To recover data after TRUNCATE, you need to use database backups or restore from a previous state.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are aggregate and scalar functions? : Sql dba

1142


What is the current version of sql?

1106


Is primary key clustered index?

1028


how to escape special characters in sql statements? : Sql dba

1124


what are all the common sql function? : Sql dba

1141


Can we use distinct and group by together?

1147


what is bcp? When does it used? : Sql dba

1065


What is the best sql course?

1064


how many tables will create when we create table, what are they? : Sql dba

1156


define sql insert statement ? : Sql dba

1110


Does group by remove duplicates?

1121


what is sql server agent? : Sql dba

1189


what is collation? : Sql dba

1242


What is the current version of postgresql?

1188


how to use regular expression in pattern match conditions? : Sql dba

1125