What is difference between TRUNCATE & DELETE?
Answer Posted / suneel
truncate:
---------
truncate is a ddl command.
ddl commands having auto commit.
delete:
-------
delete is a dml command.
dml commands not having auto commit.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is user in sql?
is mysql query is case sensitive? : Sql dba
Is sql procedural language?
What is data types in sql?
Why do we use joins?
how can we know the count/number of elements of an array? : Sql dba
What type of database is cloud sql?
What is sql and its types?
What are properties of the transaction?
What are basic techniques of indexing?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
How exception is different from error?
How many postgresql users are there, worldwide?
explain normalization concept? : Sql dba
What is sql analyzer?