Answer Posted / kiran.
Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.
Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are different sql data types?
Why is a primary key important?
What is a full join?
What is coalesce in sql?
what is a primary key? : Sql dba
What is difference between hql and sql?
What does inner join mean?
What does the argument [or replace] do?
what is recursive stored procedure? : Sql dba
Does sql support programming?
how to check myisam tables for errors? : Sql dba
Is sql a backend language?
What is 19 null in sql?
What are sql functions? Describe the different types of sql functions?
How do you get column names only for a table (sql server)?