What do you mean by DELETE command?

What do you mean by DELETE command?

Delete Command basically defines as : 
> It Can be used with or without a WHERE clause.
> It Activates Triggers.
> It can be rolled back.
> It is DML Command.
> It does not reset identity of the table.
> DELETE removes rows one at a time and records an entry in the transaction log for each deleted row.
> If we want to retain the identity counter, Which is use DELETE instead. If we want to remove table definition and its data, use the DROP TABLE statement.

Date:2010-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher