Answer Posted / nandini sett
Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
how to calculate the difference between two dates? : Sql dba
What is the difference between rename and alias?
what is bcp? When does it used? : Sql dba
Can we use ddl statements in stored procedure?
What are dml commands?
does sql support programming? : Sql dba
what is myisam? : Sql dba
What are analytic functions in sql?
How to check if a column is nullable before setting to nullable?
How do you write a complex sql query?
What is partition in sql query?
What is partition by in sql?
What does the acronym acid stand for in database management?
What is a record in pl/sql?
What is the use of stored procedures?